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,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241211-000011','06:01:41 PM','2024 12 11','admin','1','  General','  Sodexo','170.00','170.00','1',NULL,NULL,NULL,NULL,'11 Dec 2024','2024121118:01:41','%','0','170.00','no','0.00',NULL,'202412111801',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(2,'urad black whole 500g','1.0','108.00','108.00','Item',NULL,NULL,'no',NULL,NULL,'20241211-000012','06:11:22 PM','2024 12 11','admin','1','  General','  Sodexo','108.00','108.00','2',NULL,NULL,NULL,NULL,'11 Dec 2024','2024121118:11:22','%','0','108.00','no','0.00',NULL,'202412111811',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin','0',NULL,'',NULL,'108.00','','','','',NULL,'108.00'),(3,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241212-000011','02:53:52 PM','2024 12 12','admin','1','  General',NULL,'306.00','306.00','6',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121214:53:52','%','0','56.00','no','0.00',NULL,'202412121453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(4,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241212-000011','02:53:52 PM','2024 12 12','admin','1','  General',NULL,'306.00','306.00','7',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121214:53:52','%','0','250.00','no','0.00',NULL,'202412121453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(5,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241212-000012','04:29:26 PM','2024 12 12','admin','1','  General',NULL,'250.00','250.00','8',NULL,NULL,NULL,NULL,'12 Dec 2024','2024121216:29:26','%','0','250.00','no','0.00',NULL,'202412121629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(6,'tata tea bags 100dips','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000011','10:20:40 AM','2024 12 13','admin','1','  General','  Cash','30.00','100.00','10',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121310:20:40','%','0','100.00','no','0.00',NULL,'202412131020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(7,'tata tea bags 100dips','1.0','100.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000012','10:44:01 AM','2024 12 13','admin','1','  General',NULL,'100.00','100.00','11',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121310:44:01','%','0','100.00','no','0.00',NULL,'202412131044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin','0',NULL,'',NULL,'100.00','','','','',NULL,'100.00'),(8,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000013','11:43:13 AM','2024 12 13','admin','1','  General',NULL,'80.00','80.00','12',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121311:43:13','%','0','80.00','no','0.00',NULL,'202412131143',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(9,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000014','12:24:39 PM','2024 12 13','admin','1','  General',NULL,'100.00','170.00','14',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121312:24:39','%','0','170.00','no','0.00',NULL,'202412131224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(10,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000015','12:31:19 PM','2024 12 13','admin','1','  General','  Sodexo','170.00','170.00','15',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121312:31:19','%','0','170.00','no','0.00',NULL,'202412131231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(11,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000016','12:31:43 PM','2024 12 13','admin','1','  General','  Sodexo','250.00','250.00','16',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121312:31:43','%','0','250.00','no','0.00',NULL,'202412131231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(12,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000017','02:13:11 PM','2024 12 13','admin','1','  General',NULL,'180.00','250.00','21',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:13:11','%','0','250.00','no','0.00',NULL,'202412131413',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(13,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000018','02:36:23 PM','2024 12 13','admin','1','  General',NULL,'180.00','250.00','23',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:36:23','%','0','250.00','no','0.00',NULL,'202412131436',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(14,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-000019','02:38:04 PM','2024 12 13','admin','1','  General',NULL,'180.00','250.00','24',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:38:04','%','0','250.00','no','0.00',NULL,'202412131438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(15,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000110','02:38:24 PM','2024 12 13','admin','1','  General','  Cash','56.00','56.00','26',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:38:24','%','0','56.00','no','0.00',NULL,'202412131438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(16,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000111','02:39:51 PM','2024 12 13','admin','1','  General','  Cash','56.00','56.00','27',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:39:51','%','0','56.00','no','0.00',NULL,'202412131439',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(17,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000112','02:40:20 PM','2024 12 13','admin','1','  General','  Cash','56.00','56.00','28',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:40:20','%','0','56.00','no','0.00',NULL,'202412131440',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(18,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000113','02:40:32 PM','2024 12 13','admin','1','  General','  Cash','180.00','250.00','29',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:40:32','%','0','250.00','no','0.00',NULL,'202412131440',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(19,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000114','02:41:04 PM','2024 12 13','admin','1','  General','  Cash','56.00','56.00','30',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:41:04','%','0','56.00','no','0.00',NULL,'202412131441',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(20,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000115','02:56:54 PM','2024 12 13','admin','1','  General','  Cash','26.00','56.00','31',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121314:56:54','%','0','56.00','no','0.00',NULL,'202412131456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(21,'sona masoori raw rice 1kg','2.0','56.00','112.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000116','03:18:19 PM','2024 12 13','admin','1','  General','  Sodexo','112.00','112.00','32',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121315:18:19','%','0','112.00','no','0.00',NULL,'202412131518',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'112.00','','','','',NULL,'56.00'),(22,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000117','03:18:40 PM','2024 12 13','admin','1','  General','  Sodexo','56.00','56.00','33',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121315:18:40','%','0','56.00','no','0.00',NULL,'202412131518',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(23,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000118','03:22:54 PM','2024 12 13','admin','1','  General',NULL,'80.00','80.00','34',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121315:22:54','%','0','80.00','no','0.00',NULL,'202412131522',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(24,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000119','05:50:50 PM','2024 12 13','admin','1','  General',NULL,'250.00','250.00','38',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121317:50:50','%','0','250.00','no','0.00',NULL,'202412131750',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(25,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000120','05:56:59 PM','2024 12 13','admin','1','  General',NULL,'250.00','250.00','39',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121317:56:59','%','0','250.00','no','0.00',NULL,'202412131756',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(26,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000121','06:08:04 PM','2024 12 13','admin','1','  General','  Cash','220.00','250.00','40',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121318:08:04','%','0','250.00','no','0.00',NULL,'202412131808',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(27,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000122','06:14:26 PM','2024 12 13','admin','1','  General','  Sodexo','56.00','56.00','43',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121318:14:26','%','0','56.00','no','0.00',NULL,'202412131814',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(28,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000123','06:17:34 PM','2024 12 13','admin','1','  General','  Sodexo','56.00','56.00','44',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121318:17:34','%','0','56.00','no','0.00',NULL,'202412131817',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(29,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000124','06:18:11 PM','2024 12 13','admin','1','  General','  Sodexo','250.00','250.00','46',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121318:18:11','%','0','250.00','no','0.00',NULL,'202412131818',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(30,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241213-0000125','06:57:39 PM','2024 12 13','admin','1','  General',NULL,'250.00','250.00','49',NULL,NULL,NULL,NULL,'13 Dec 2024','2024121318:57:39','%','0','250.00','no','0.00',NULL,'202412131857',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(31,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000011','12:13:40 AM','2024 12 16','admin','1','  General',NULL,'250.00','250.00','50',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121600:13:40','%','0','250.00','no','0.00',NULL,'202412160013',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(32,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000012','01:00:46 AM','2024 12 16','admin','1','  General',NULL,'170.00','170.00','51',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121601:00:46','%','0','170.00','no','0.00',NULL,'202412160100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(33,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000013','10:25:58 AM','2024 12 16','admin','1','  General',NULL,'250.00','250.00','53',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121610:25:58','%','0','250.00','no','0.00',NULL,'202412161025',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(34,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000014','11:02:33 AM','2024 12 16','admin','1','  General',NULL,'56.00','56.00','56',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121611:02:33','%','0','56.00','no','0.00',NULL,'202412161102',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(35,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000015','11:03:42 AM','2024 12 16','admin','1','  General',NULL,'250.00','250.00','57',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121611:03:42','%','0','250.00','no','0.00',NULL,'202412161103',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(36,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000016','11:54:56 AM','2024 12 16','admin','1','  General',NULL,'56.00','56.00','61',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121611:54:56','%','0','56.00','no','0.00',NULL,'202412161154',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(37,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000017','12:19:47 PM','2024 12 16','admin','1','  General',NULL,'56.00','56.00','62',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:19:47','%','0','56.00','no','0.00',NULL,'202412161219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(38,'tata tea fusion assan tea  and  kenyan tea 100gm','1.0','50.00','50.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000018','12:20:48 PM','2024 12 16','admin','1','  General',NULL,'70.00','70.00','63',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:20:48','%','0','50.00','no','0.00',NULL,'202412161220',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin','0',NULL,'',NULL,'50.00','','','','',NULL,'50.00'),(39,'tide 190gms','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000018','12:20:48 PM','2024 12 16','admin','1','  General',NULL,'70.00','70.00','64',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:20:48','%','0','20.00','no','0.00',NULL,'202412161220',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin','0',NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(40,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000019','12:21:37 PM','2024 12 16','admin','1','  General','  Sodexo','806.00','806.00','65',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:21:37','%','0','56.00','no','0.00',NULL,'202412161221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin','0',NULL,'',NULL,'56.00','','','','',NULL,'56.00'),(41,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000019','12:21:37 PM','2024 12 16','admin','1','  General','  Sodexo','806.00','806.00','66',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:21:37','%','0','250.00','no','0.00',NULL,'202412161221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(42,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000019','12:21:37 PM','2024 12 16','admin','1','  General','  Sodexo','806.00','806.00','67',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:21:37','%','0','170.00','no','0.00',NULL,'202412161221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(43,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000019','12:21:37 PM','2024 12 16','admin','1','  General','  Sodexo','806.00','806.00','68',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:21:37','%','0','250.00','no','0.00',NULL,'202412161221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'250.00','','','','',NULL,'250.00'),(44,'capsicum green kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000019','12:21:37 PM','2024 12 16','admin','1','  General','  Sodexo','806.00','806.00','69',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:21:37','%','0','80.00','no','0.00',NULL,'202412161221',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin','0',NULL,'',NULL,'80.00','','','','',NULL,'80.00'),(45,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-0000110','12:36:46 PM','2024 12 16','admin','1','  General','  Cash','100.00','170.00','70',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:36:46','%','0','170.00','no','0.00',NULL,'202412161236',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(46,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-0000111','12:37:15 PM','2024 12 16','admin','1','  General','  Cash','170.00','170.00','71',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121612:37:15','%','0','170.00','no','0.00',NULL,'202412161237',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(47,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-0000112','03:09:50 PM','2024 12 16','admin','1','  General',NULL,'170.00','170.00','72',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121615:09:50','%','0','170.00','no','0.00',NULL,'202412161509',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(48,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-0000113','03:14:34 PM','2024 12 16','admin','1','  General',NULL,'170.00','170.00','73',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121615:14:34','%','0','170.00','no','0.00',NULL,'202412161514',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(49,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000011','03:32:52 PM','2024 12 16','admin','1','  General','  Cash','100.00','170.00','1',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121615:32:52','%','0','170.00','no','0.00',NULL,'202412161532',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,'170.00','','','','',NULL,'170.00'),(50,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241216-000012','03:33:05 PM','2024 12 16','admin','1','  General','  Cash','100.0','170.00','2',NULL,NULL,NULL,NULL,'16 Dec 2024','2024121615:33:05','%','0','170.00','no','0.00',NULL,'202412161533',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin','0',NULL,'',NULL,'170.00','','','','',NULL,'170.00');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2024 12 12','02:53:52 PM','20241212-000011','Pushpanjali Coupon','7.48','306.00','22.88%','12 Dec 2024','306.00',NULL,'202412121453',NULL),(2,'2024 12 12','04:29:26 PM','20241212-000012','Pushpanjali Coupon','11.20','250.00','28.00%','12 Dec 2024','250.00',NULL,'202412121629',NULL),(3,'2024 12 13','10:20:40 AM','20241213-000011','D70','70.00','30.00','70','13 Dec 2024','100.00',NULL,'202412131020',NULL),(4,'2024 12 13','10:44:01 AM','20241213-000012','Pushpanjali Coupon','233.33','100.00','70.00%','13 Dec 2024','100.00',NULL,'202412131044',NULL),(5,'2024 12 13','11:43:13 AM','20241213-000013','Pushpanjali Coupon','875.00','80.00','87.50%','13 Dec 2024','80.00',NULL,'202412131143',NULL),(6,'2024 12 13','12:24:39 PM','20241213-000014','Pushpanjali Coupon','24.22','100.00','41.18%','13 Dec 2024','170.00',NULL,'202412131224',NULL),(7,'2024 12 13','02:13:11 PM','20241213-000017','Pushpanjali Coupon','11.20','180.00','28.00%','13 Dec 2024','250.00',NULL,'202412131413',NULL),(8,'2024 12 13','02:36:23 PM','20241213-000018','Pushpanjali Coupon','11.20','180.00','28.00%','13 Dec 2024','250.00',NULL,'202412131436',NULL),(9,'2024 12 13','02:38:04 PM','20241213-000019','Pushpanjali Coupon','11.20','180.00','28.00%','13 Dec 2024','250.00',NULL,'202412131438',NULL),(10,'2024 12 13','02:40:32 PM','20241213-0000113','Pushpanjali Coupon','11.20','180.00','28.00%','13 Dec 2024','250.00',NULL,'202412131440',NULL),(11,'2024 12 13','02:56:54 PM','20241213-0000115','D30','53.57','26.00','30','13 Dec 2024','56.00',NULL,'202412131456',NULL),(12,'2024 12 13','03:22:54 PM','20241213-0000118','Pushpanjali Coupon','109.38','80.00','87.50%','13 Dec 2024','80.00',NULL,'202412131522',NULL),(13,'2024 12 13','05:50:50 PM','20241213-0000119','Pushpanjali Coupon','11.20','250.00','28.00%','13 Dec 2024','250.00',NULL,'202412131750',NULL),(14,'2024 12 13','05:56:59 PM','20241213-0000120','Pushpanjali Coupon','11.20','250.00','28.00%','13 Dec 2024','250.00',NULL,'202412131756',NULL),(15,'2024 12 13','06:08:04 PM','20241213-0000121','30d','12.00','220.00','30','13 Dec 2024','250.00',NULL,'202412131808',NULL),(16,'2024 12 13','06:18:11 PM','20241213-0000124','Pushpanjali Coupon','11.20','250.00','28.00%','13 Dec 2024','250.00',NULL,'202412131818',NULL),(17,'2024 12 13','06:57:39 PM','20241213-0000125','Pushpanjali Coupon','28.00','250.00','70.00','13 Dec 2024','250.00',NULL,'202412131857',NULL),(18,'2024 12 16','12:13:40 AM','20241216-000011','Pushpanjali Coupon','28.00','250.00','70.00','16 Dec 2024','250.00',NULL,'202412160013',NULL),(19,'2024 12 16','01:00:46 AM','20241216-000012','Pushpanjali Coupon','82.35','170.00','140.00','16 Dec 2024','170.00',NULL,'202412160100',NULL),(20,'2024 12 16','10:25:58 AM','20241216-000013','Pushpanjali Coupon','56.00','250.00','140.00','16 Dec 2024','250.00',NULL,'202412161025',NULL),(21,'2024 12 16','11:02:33 AM','20241216-000014','Pushpanjali Coupon','125.00','56.00','70.00','16 Dec 2024','56.00',NULL,'202412161102',NULL),(22,'2024 12 16','11:03:42 AM','20241216-000015','Pushpanjali Coupon','28.00','250.00','70.00','16 Dec 2024','250.00',NULL,'202412161103',NULL),(23,'2024 12 16','11:54:56 AM','20241216-000016','Pushpanjali Coupon','125.00','56.00','70.00','16 Dec 2024','56.00',NULL,'202412161154',NULL),(24,'2024 12 16','12:19:47 PM','20241216-000017','Pushpanjali Coupon','100.00','56.00','56.00','16 Dec 2024','56.00',NULL,'202412161219',NULL),(25,'2024 12 16','12:20:48 PM','20241216-000018','Pushpanjali Coupon','100.00','70.00','70.00','16 Dec 2024','70.00',NULL,'202412161220',NULL),(26,'2024 12 16','12:36:46 PM','20241216-0000110','pp','41.18','100.00','70','16 Dec 2024','170.00',NULL,'202412161236',NULL),(27,'2024 12 16','12:37:15 PM','20241216-0000111','Pushpanjali Coupon','41.18','170.00','70.00','16 Dec 2024','170.00',NULL,'202412161237',NULL),(28,'2024 12 16','03:09:50 PM','20241216-0000112','Pushpanjali Coupon','41.18','170.00','70.00','16 Dec 2024','170.00',NULL,'202412161509',NULL),(29,'2024 12 16','03:14:34 PM','20241216-0000113','Pushpanjali Coupon','41.18','170.00','70.00','16 Dec 2024','170.00',NULL,'202412161514',NULL),(30,'2024 12 16','03:32:52 PM','20241216-000011','pp','41.18','100.00','70','16 Dec 2024','170.00',NULL,'202412161532',NULL),(31,'2024 12 16','03:33:05 PM','20241216-000012','Pushpanjali Coupon','41.18','100.0','70.00','16 Dec 2024','170.00',NULL,'202412161533',NULL);
