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,'mathi','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20260428-000011','11:59:06 AM','2026 04 28','admin','1','  General','  Cash','320.00','320.00','6',NULL,NULL,NULL,NULL,'28 Apr 2026','2026042811:59:06','%','0','320.00','no','0.00',NULL,'202604281159','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'320.00','','','','',NULL,'320.00'),(2,'white eral','1.0','580.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20260428-000012','12:03:46 PM','2026 04 28','admin','1','  General','  Cash','580.00','580.00','7',NULL,NULL,NULL,NULL,'28 Apr 2026','2026042812:03:46','%','0','580.00','no','0.00',NULL,'202604281203','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'580.00','','','','',NULL,'580.00'),(3,'mathi','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20260428-000013','12:05:32 PM','2026 04 28','admin','1','  General','  Cash','320.00','320.00','8',NULL,NULL,NULL,NULL,'28 Apr 2026','2026042812:05:32','%','0','320.00','no','0.00',NULL,'202604281205','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'320.00','','','','',NULL,'320.00'),(4,'mathi','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20260428-000014','12:07:01 PM','2026 04 28','admin','1','  General','  Cash','320.00','320.00','9',NULL,NULL,NULL,NULL,'28 Apr 2026','2026042812:07:01','%','0','320.00','no','0.00',NULL,'202604281207','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'320.00','','','','',NULL,'320.00'),(5,'white eral','0.5','580.00','290.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000011','07:25:50 AM','2026 04 29','admin','1','  General','  Cash','722.00','722.00','10',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:25:50','%','0','580.00','no','0.00',NULL,'202604290725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'290.00','','','','',NULL,'580.00'),(6,'vf 1','0.9','480.00','432.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000011','07:25:50 AM','2026 04 29','admin','1','  General','  Cash','722.00','722.00','11',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:25:50','%','0','480.00','no','0.00',NULL,'202604290725','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'432.00','','','','',NULL,'480.00'),(7,'vangada','1.5','380.00','570.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000012','07:27:21 AM','2026 04 29','admin','1','  General','  Cash','570.00','570.00','12',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:27:21','%','0','380.00','no','0.00',NULL,'202604290727','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'570.00','','','','',NULL,'380.00'),(8,'sangara','1.0','540.00','540.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000013','07:29:25 AM','2026 04 29','admin','1','  General','  Cash','540.00','540.00','13',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:29:25','%','0','540.00','no','0.00',NULL,'202604290729','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'540.00','','','','',NULL,'540.00'),(9,'sangara','0.5','540.00','270.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000014','07:45:30 AM','2026 04 29','admin','1','  General','  Cash','270.00','270.00','16',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:45:30','%','0','540.00','no','0.00',NULL,'202604290745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'270.00','','','','',NULL,'540.00'),(10,'pasunthi','0.7','480.00','336.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000015','07:46:50 AM','2026 04 29','admin','1','  General','  Cash','696.00','696.00','17',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:46:50','%','0','480.00','no','0.00',NULL,'202604290746','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'336.00','','','','',NULL,'480.00'),(11,'aila','1.0','360.00','360.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000015','07:46:50 AM','2026 04 29','admin','1','  General','  Cash','696.00','696.00','18',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:46:50','%','0','360.00','no','0.00',NULL,'202604290746','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'360.00','','','','',NULL,'360.00'),(12,'aila','1.0','390.00','390.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000016','07:52:52 AM','2026 04 29','admin','1','  General','  Cash','726.00','726.00','19',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:52:52','%','0','390.00','no','0.00',NULL,'202604290752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'390.00','','','','',NULL,'390.00'),(13,'pasunthi','0.7','480.00','336.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000016','07:52:52 AM','2026 04 29','admin','1','  General','  Cash','726.00','726.00','20',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042907:52:52','%','0','480.00','no','0.00',NULL,'202604290752','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'336.00','','','','',NULL,'480.00'),(14,'koduva','1.45','450.00','652.50','Item',NULL,NULL,'no',NULL,NULL,'20260429-000017','08:21:01 AM','2026 04 29','admin','1','  General','  Cash','1292.50','1292.50','22',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042908:21:01','%','0','450.00','no','0.00',NULL,'202604290821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'652.50','','','','',NULL,'450.00'),(15,'mathi','2.0','320.00','640.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000017','08:21:01 AM','2026 04 29','admin','1','  General','  Cash','1292.50','1292.50','23',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042908:21:01','%','0','320.00','no','0.00',NULL,'202604290821','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'640.00','','','','',NULL,'320.00'),(16,'kan nandu','1.0','480.00','480.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000018','09:21:37 AM','2026 04 29','admin','1','  General','  Cash','480.00','480.00','24',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042909:21:37','%','0','480.00','no','0.00',NULL,'202604290921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'480.00','','','','',NULL,'480.00'),(17,'nethili','1.0','540.00','540.00','Item',NULL,NULL,'no',NULL,NULL,'20260429-000019','09:24:21 AM','2026 04 29','admin','1','  General','  Cash','540.00','540.00','25',NULL,NULL,NULL,NULL,'29 Apr 2026','2026042909:24:21','%','0','540.00','no','0.00',NULL,'202604290924','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'540.00','','','','',NULL,'540.00'),(18,'vellai kilangan','1.0','650.00','650.00','Item',NULL,NULL,'no',NULL,NULL,'20260502-000011','08:19:24 AM','2026 05 02','admin','1','  General','  Cash','940.00','940.00','39',NULL,NULL,NULL,NULL,'02 May 2026','2026050208:19:24','%','0','650.00','no','0.00',NULL,'202605020819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'650.00','','','','',NULL,'650.00'),(19,'white eral','0.5','580.00','290.00','Item',NULL,NULL,'no',NULL,NULL,'20260502-000011','08:19:24 AM','2026 05 02','admin','1','  General','  Cash','940.00','940.00','40',NULL,NULL,NULL,NULL,'02 May 2026','2026050208:19:24','%','0','580.00','no','0.00',NULL,'202605020819','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'290.00','','','','',NULL,'580.00'),(20,'vanjaram slice','0.79','1700.00','1343.00','Item',NULL,NULL,'no',NULL,NULL,'20260502-000012','08:42:42 AM','2026 05 02','admin','1','  General','  Cash','1343.00','1343.00','41',NULL,NULL,NULL,NULL,'02 May 2026','2026050208:42:42','%','0','1700.00','no','0.00',NULL,'202605020842','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1343.00','','','','',NULL,'1700.00'),(21,'mathi','1.0','330.00','330.00','Item',NULL,NULL,'no',NULL,NULL,'20260502-000013','09:23:38 AM','2026 05 02','admin','1','  General','  Cash','330.00','330.00','42',NULL,NULL,NULL,NULL,'02 May 2026','2026050209:23:38','%','0','330.00','no','0.00',NULL,'202605020923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'330.00','','','','',NULL,'330.00'),(22,'vf super','1.0','650.00','650.00','Item',NULL,NULL,'no',NULL,NULL,'20260502-000014','12:36:54 PM','2026 05 02','admin','1','  General','  Cash','650.00','650.00','43',NULL,NULL,NULL,NULL,'02 May 2026','2026050212:36:54','%','0','650.00','no','0.00',NULL,'202605021236','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'650.00','','','','',NULL,'650.00'),(23,'vf super','1.17','650.00','760.50','Item',NULL,NULL,'no',NULL,NULL,'20260503-000011','06:26:51 AM','2026 05 03','admin','1','  General','  Cash','760.50','760.50','44',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:26:51','%','0','650.00','no','0.00',NULL,'202605030626','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'760.50','','','','',NULL,'650.00'),(24,'vf super','1.17','590.00','690.30','Item',NULL,NULL,'no',NULL,NULL,'20260503-000012','06:27:52 AM','2026 05 03','admin','1','  General','  Cash','690.30','690.30','45',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:27:52','%','0','590.00','no','0.00',NULL,'202605030627','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'690.30','','','','',NULL,'590.00'),(25,'white eral','1.0','580.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000013','06:38:24 AM','2026 05 03','admin','1','  General','  Cash','1130.00','1130.00','47',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:38:24','%','0','580.00','no','0.00',NULL,'202605030638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'580.00','','','','',NULL,'580.00'),(26,'squid','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000013','06:38:24 AM','2026 05 03','admin','1','  General','  Cash','1130.00','1130.00','48',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:38:24','%','0','550.00','no','0.00',NULL,'202605030638','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(27,'m kola','1.0','680.00','680.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000014','06:44:31 AM','2026 05 03','admin','1','  General','  Cash','680.00','680.00','50',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:44:31','%','0','680.00','no','0.00',NULL,'202605030644','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'680.00','','','','',NULL,'680.00'),(28,'m kola','1.6','680.00','1088.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000015','06:56:36 AM','2026 05 03','admin','1','  General','  Cash','1088.00','1088.00','51',NULL,NULL,NULL,NULL,'03 May 2026','2026050306:56:36','%','0','680.00','no','0.00',NULL,'202605030656','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1088.00','','','','',NULL,'680.00'),(29,'parI','1.0','580.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000016','07:00:16 AM','2026 05 03','admin','1','  General','  Cash','580.00','580.00','53',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:00:16','%','0','580.00','no','0.00',NULL,'202605030700','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'580.00','','','','',NULL,'580.00'),(30,'m kola','1.0','680.00','680.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000017','07:01:07 AM','2026 05 03','admin','1','  General','  Cash','680.00','680.00','54',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:01:07','%','0','680.00','no','0.00',NULL,'202605030701','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'680.00','','','','',NULL,'680.00'),(31,'vanjaram slice','2.28','1450.00','3306.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000018','07:02:00 AM','2026 05 03','admin','1','  General','  Cash','3306.00','3306.00','55',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:02:00','%','0','1450.00','no','0.00',NULL,'202605030702','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'3306.00','','','','',NULL,'1450.00'),(32,'parI','1.26','580.00','730.80','Item',NULL,NULL,'no',NULL,NULL,'20260503-000019','07:14:36 AM','2026 05 03','admin','1','  General','  Cash','1078.80','1078.80','56',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:14:36','%','0','580.00','no','0.00',NULL,'202605030714','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'730.80','','','','',NULL,'580.00'),(33,'white eral','0.6','580.00','348.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-000019','07:14:36 AM','2026 05 03','admin','1','  General','  Cash','1078.80','1078.80','57',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:14:36','%','0','580.00','no','0.00',NULL,'202605030714','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'348.00','','','','',NULL,'580.00'),(34,'kili meen','0.54','580.00','313.20','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000110','07:16:04 AM','2026 05 03','admin','1','  General','  Cash','313.20','313.20','58',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:16:04','%','0','580.00','no','0.00',NULL,'202605030716','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'313.20','','','','',NULL,'580.00'),(35,'vf super','2.1','590.00','1239.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000111','07:24:26 AM','2026 05 03','admin','1','  General','  Cash','1239.00','1239.00','60',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:24:26','%','0','590.00','no','0.00',NULL,'202605030724','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1239.00','','','','',NULL,'590.00'),(36,'mathi','0.8','330.00','264.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000112','07:26:13 AM','2026 05 03','admin','1','  General','  Cash','264.00','264.00','61',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:26:13','%','0','330.00','no','0.00',NULL,'202605030726','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'264.00','','','','',NULL,'330.00'),(37,'manja kili','1.10','400.00','440.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000113','07:27:55 AM','2026 05 03','admin','1','  General','  Cash','440.00','440.00','62',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:27:55','%','0','400.00','no','0.00',NULL,'202605030727','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'440.00','','','','',NULL,'400.00'),(38,'sangara','2','550.00','1100.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000114','07:31:57 AM','2026 05 03','admin','1','  General','  Cash','2550.00','2550.00','63',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:31:57','%','0','550.00','no','0.00',NULL,'202605030731','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1100.00','','','','',NULL,'550.00'),(39,'vanjaram slice','1.0','1450.00','1450.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000114','07:31:57 AM','2026 05 03','admin','1','  General','  Cash','2550.00','2550.00','64',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:31:57','%','0','1450.00','no','0.00',NULL,'202605030731','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1450.00','','','','',NULL,'1450.00'),(40,'sangara','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000115','07:33:11 AM','2026 05 03','admin','1','  General','  Cash','550.00','550.00','65',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:33:11','%','0','550.00','no','0.00',NULL,'202605030733','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(41,'sangara','0.67','550.00','368.50','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000116','07:35:32 AM','2026 05 03','admin','1','  General','  Cash','807.40','807.40','66',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:35:32','%','0','550.00','no','0.00',NULL,'202605030735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'368.50','','','','',NULL,'550.00'),(42,'mathi','1.33','330.00','438.90','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000116','07:35:32 AM','2026 05 03','admin','1','  General','  Cash','807.40','807.40','67',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:35:32','%','0','330.00','no','0.00',NULL,'202605030735','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'438.90','','','','',NULL,'330.00'),(43,'white eral','1.0','580.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000117','07:45:22 AM','2026 05 03','admin','1','  General','  Cash','580.00','580.00','68',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:45:22','%','0','580.00','no','0.00',NULL,'202605030745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'580.00','','','','',NULL,'580.00'),(44,'thengai paarai','2.38','680.00','1618.40','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000118','07:47:30 AM','2026 05 03','admin','1','  General','  Cash','1618.40','1618.40','69',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:47:30','%','0','680.00','no','0.00',NULL,'202605030747','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'1618.40','','','','',NULL,'680.00'),(45,'m kola','1.35','680.00','918.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000119','07:54:03 AM','2026 05 03','admin','1','  General','  Cash','918.00','918.00','70',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:54:03','%','0','680.00','no','0.00',NULL,'202605030754','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'918.00','','','','',NULL,'680.00'),(46,'m kola','.263','680.00','178.84','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000120','07:55:01 AM','2026 05 03','admin','1','  General','  Cash','178.84','178.84','71',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:55:01','%','0','1360.00','no','0.00',NULL,'202605030755','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'178.84','','','','',NULL,'680.00'),(47,'sangara','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000121','07:56:30 AM','2026 05 03','admin','1','  General','  Cash','550.00','550.00','72',NULL,NULL,NULL,NULL,'03 May 2026','2026050307:56:30','%','0','550.00','no','0.00',NULL,'202605030756','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(48,'sangara','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000122','08:03:16 AM','2026 05 03','admin','1','  General','  Cash','550.00','550.00','73',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:03:16','%','0','550.00','no','0.00',NULL,'202605030803','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'550.00','','','','',NULL,'550.00'),(49,'ma paarai','1.50','580.00','870.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000123','08:07:21 AM','2026 05 03','admin','1','  General','  Cash','870.00','870.00','75',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:07:21','%','0','580.00','no','0.00',NULL,'202605030807','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'870.00','','','','',NULL,'580.00'),(50,'vf 1','0.5','480.00','240.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000124','08:17:32 AM','2026 05 03','admin','1','  General','  Cash','240.00','240.00','76',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:17:32','%','0','480.00','no','0.00',NULL,'202605030817','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'240.00','','','','',NULL,'480.00'),(51,'white eral','1.0','580.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000125','08:33:04 AM','2026 05 03','admin','1','  General','  Cash','580.00','580.00','77',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:33:04','%','0','580.00','no','0.00',NULL,'202605030833','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'580.00','','','','',NULL,'580.00'),(52,'oodagam','1.08','480.00','518.40','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000126','08:34:24 AM','2026 05 03','admin','1','  General','  Cash','518.40','518.40','78',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:34:24','%','0','480.00','no','0.00',NULL,'202605030834','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'518.40','','','','',NULL,'480.00'),(53,'manja kili','2.10','400.00','840.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000127','08:36:07 AM','2026 05 03','admin','1','  General','  Cash','840.00','840.00','79',NULL,NULL,NULL,NULL,'03 May 2026','2026050308:36:07','%','0','400.00','no','0.00',NULL,'202605030836','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'840.00','','','','',NULL,'400.00'),(54,'vf 1','0.6','480.00','288.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000128','09:00:51 AM','2026 05 03','admin','1','  General','  Cash','288.00','288.00','81',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:00:51','%','0','480.00','no','0.00',NULL,'202605030900','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'288.00','','','','',NULL,'480.00'),(55,'manja kili','1.0','400.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000129','09:05:59 AM','2026 05 03','admin','1','  General','  Cash','400.00','400.00','82',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:05:59','%','0','400.00','no','0.00',NULL,'202605030905','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'400.00','','','','',NULL,'400.00'),(56,'vanjaram slice','0.49','1450.00','710.50','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000130','09:13:39 AM','2026 05 03','admin','1','  General','  Cash','1000.50','1000.50','83',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:13:39','%','0','1450.00','no','0.00',NULL,'202605030913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'710.50','','','','',NULL,'1450.00'),(57,'white eral','0.5','580.00','290.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000130','09:13:39 AM','2026 05 03','admin','1','  General','  Cash','1000.50','1000.50','84',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:13:39','%','0','580.00','no','0.00',NULL,'202605030913','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'290.00','','','','',NULL,'580.00'),(58,'kili meen','0.8','580.00','464.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000131','09:23:37 AM','2026 05 03','admin','1','  General','  Cash','464.00','464.00','86',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:23:37','%','0','580.00','no','0.00',NULL,'202605030923','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'464.00','','','','',NULL,'580.00'),(59,'vanjaram slice','0.37','1450.00','536.50','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000132','09:26:18 AM','2026 05 03','admin','1','  General','  Cash','1042.40','1042.40','87',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:26:18','%','0','1450.00','no','0.00',NULL,'202605030926','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'536.50','','','','',NULL,'1450.00'),(60,'mathi','0.83','330.00','273.90','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000132','09:26:18 AM','2026 05 03','admin','1','  General','  Cash','1042.40','1042.40','88',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:26:18','%','0','330.00','no','0.00',NULL,'202605030926','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'273.90','','','','',NULL,'330.00'),(61,'white eral','0.4','580.00','232.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000132','09:26:18 AM','2026 05 03','admin','1','  General','  Cash','1042.40','1042.40','89',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:26:18','%','0','580.00','no','0.00',NULL,'202605030926','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'232.00','','','','',NULL,'580.00'),(62,'mural','1.20','550.00','660.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000133','09:28:04 AM','2026 05 03','admin','1','  General','  Cash','660.00','660.00','90',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:28:04','%','0','550.00','no','0.00',NULL,'202605030928','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'660.00','','','','',NULL,'550.00'),(63,'mural','0.72','550.00','396.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000134','09:35:55 AM','2026 05 03','admin','1','  General','  Cash','396.00','396.00','91',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:35:55','%','0','550.00','no','0.00',NULL,'202605030935','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'396.00','','','','',NULL,'550.00'),(64,'vanjaram slice','0.28','1450.00','406.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000135','09:40:17 AM','2026 05 03','admin','1','  General','  Cash','406.00','406.00','92',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:40:17','%','0','1450.00','no','0.00',NULL,'202605030940','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'406.00','','','','',NULL,'1450.00'),(65,'vf super','1.19','590.00','702.10','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000136','09:45:42 AM','2026 05 03','admin','1','  General','  Cash','702.10','702.10','93',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:45:42','%','0','590.00','no','0.00',NULL,'202605030945','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'702.10','','','','',NULL,'590.00'),(66,'leather jacket','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000137','09:51:18 AM','2026 05 03','admin','1','  General','  Cash','350.00','350.00','94',NULL,NULL,NULL,NULL,'03 May 2026','2026050309:51:18','%','0','350.00','no','0.00',NULL,'202605030951','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'350.00','','','','',NULL,'350.00'),(67,'kili meen','0.64','580.00','371.20','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000138','10:03:37 AM','2026 05 03','admin','1','  General','  Cash','371.20','371.20','97',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:03:37','%','0','580.00','no','0.00',NULL,'202605031003','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'371.20','','','','',NULL,'580.00'),(68,'manja kili','0.59','400.00','236.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000139','10:13:45 AM','2026 05 03','admin','1','  General','  Cash','461.60','461.60','98',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:13:45','%','0','400.00','no','0.00',NULL,'202605031013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'236.00','','','','',NULL,'400.00'),(69,'seppuli','0.47','480.00','225.60','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000139','10:13:45 AM','2026 05 03','admin','1','  General','  Cash','461.60','461.60','99',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:13:45','%','0','480.00','no','0.00',NULL,'202605031013','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'225.60','','','','',NULL,'480.00'),(70,'oodagam','0.63','480.00','302.40','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000140','10:25:20 AM','2026 05 03','admin','1','  General','  Cash','302.40','302.40','100',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:25:20','%','0','480.00','no','0.00',NULL,'202605031025','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'302.40','','','','',NULL,'480.00'),(71,'manja kili','0.78','400.00','312.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000141','10:28:38 AM','2026 05 03','admin','1','  General','  Cash','312.00','312.00','101',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:28:38','%','0','400.00','no','0.00',NULL,'202605031028','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'312.00','','','','',NULL,'400.00'),(72,'manja kili','1.22','400.00','488.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000142','10:33:11 AM','2026 05 03','admin','1','  General','  Cash','488.00','488.00','102',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:33:11','%','0','400.00','no','0.00',NULL,'202605031033','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'488.00','','','','',NULL,'400.00'),(73,'manja kili','1.07','400.00','428.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000143','10:43:35 AM','2026 05 03','admin','1','  General','  Cash','428.00','428.00','103',NULL,NULL,NULL,NULL,'03 May 2026','2026050310:43:35','%','0','400.00','no','0.00',NULL,'202605031043','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'428.00','','','','',NULL,'400.00'),(74,'mathi','0.5','330.00','165.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000144','11:03:33 AM','2026 05 03','admin','1','  General','  Cash','489.80','489.80','104',NULL,NULL,NULL,NULL,'03 May 2026','2026050311:03:33','%','0','330.00','no','0.00',NULL,'202605031103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'165.00','','','','',NULL,'330.00'),(75,'white eral','0.56','580.00','324.80','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000144','11:03:33 AM','2026 05 03','admin','1','  General','  Cash','489.80','489.80','105',NULL,NULL,NULL,NULL,'03 May 2026','2026050311:03:33','%','0','580.00','no','0.00',NULL,'202605031103','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'324.80','','','','',NULL,'580.00'),(76,'white eral','0.75','580.00','435.00','Item',NULL,NULL,'no',NULL,NULL,'20260503-0000145','12:15:22 PM','2026 05 03','admin','1','  General','  Cash','435.00','435.00','106',NULL,NULL,NULL,NULL,'03 May 2026','2026050312:15:22','%','0','580.00','no','0.00',NULL,'202605031215','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,'435.00','','','','',NULL,'580.00');
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`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20260428-000011','320.00','admin','2026 04 28','  Cash','  General','320.00','0.00','0.00','0.0','1','202604281159',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20260428-000012','580.00','admin','2026 04 28','  Cash','  General','580.00','0.00','0.00','0.0','2','202604281203',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20260428-000013','320.00','admin','2026 04 28','  Cash','  General','320.00','0.00','0.00','0.0','3','202604281205',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20260428-000014','320.00','admin','2026 04 28','  Cash','  General','320.00','0.00','0.00','0.0','_4','202604281207',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(5,'20260429-000011','722.00','admin','2026 04 29','  Cash','  General','722.00','0.00','0.00','0.0','_5','202604290725',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(6,'20260429-000012','570.00','admin','2026 04 29','  Cash','  General','570.00','0.00','0.00','0.0','_6','202604290727',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260429-000013','540.00','admin','2026 04 29','  Cash','  General','540.00','0.00','0.00','0.0','_7','202604290729',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260429-000014','270.00','admin','2026 04 29','  Cash','  General','270.00','0.00','0.00','0.0','_8','202604290745',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260429-000015','696.00','admin','2026 04 29','  Cash','  General','696.00','0.00','0.00','0.0','_9','202604290746',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260429-000016','726.00','admin','2026 04 29','  Cash','  General','726.00','0.00','0.00','0.0','_10','202604290752',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260429-000017','1292.50','admin','2026 04 29','  Cash','  General','1292.50','0.00','0.00','0.0','_11','202604290821',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260429-000018','480.00','admin','2026 04 29','  Cash','  General','480.00','0.00','0.00','0.0','_12','202604290921',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260429-000019','540.00','admin','2026 04 29','  Cash','  General','540.00','0.00','0.00','0.0','_13','202604290924',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260502-000011','940.00','admin','2026 05 02','  Cash','  General','940.00','0.00','0.00','0.0','_14','202605020819',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260502-000012','1343.00','admin','2026 05 02','  Cash','  General','1343.00','0.00','0.00','0.0','_15','202605020842',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260502-000013','330.00','admin','2026 05 02','  Cash','  General','330.00','0.00','0.00','0.0','_16','202605020923',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(17,'20260502-000014','650.00','admin','2026 05 02','  Cash','  General','650.00','0.00','0.00','0.0','_17','202605021236',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(18,'20260503-000011','760.50','admin','2026 05 03','  Cash','  General','760.50','0.00','0.00','0.0','_18','202605030626',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(19,'20260503-000012','690.30','admin','2026 05 03','  Cash','  General','690.30','0.00','0.00','0.0','_19','202605030627',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(20,'20260503-000013','1130.00','admin','2026 05 03','  Cash','  General','1130.00','0.00','0.00','0.0','_20','202605030638',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(21,'20260503-000014','680.00','admin','2026 05 03','  Cash','  General','680.00','0.00','0.00','0.0','_21','202605030644',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(22,'20260503-000015','1088.00','admin','2026 05 03','  Cash','  General','1088.00','0.00','0.00','0.0','_22','202605030656',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(23,'20260503-000016','580.00','admin','2026 05 03','  Cash','  General','580.00','0.00','0.00','0.0','_23','202605030700',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(24,'20260503-000017','680.00','admin','2026 05 03','  Cash','  General','680.00','0.00','0.00','0.0','_24','202605030701',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(25,'20260503-000018','3306.00','admin','2026 05 03','  Cash','  General','3306.00','0.00','0.00','0.0','_25','202605030702',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(26,'20260503-000019','1078.80','admin','2026 05 03','  Cash','  General','1078.80','0.00','0.00','0.0','_26','202605030714',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(27,'20260503-0000110','313.20','admin','2026 05 03','  Cash','  General','313.20','0.00','0.00','0.0','_27','202605030716',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(28,'20260503-0000111','1239.00','admin','2026 05 03','  Cash','  General','1239.00','0.00','0.00','0.0','_28','202605030724',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(29,'20260503-0000112','264.00','admin','2026 05 03','  Cash','  General','264.00','0.00','0.00','0.0','_29','202605030726',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(30,'20260503-0000113','440.00','admin','2026 05 03','  Cash','  General','440.00','0.00','0.00','0.0','_30','202605030727',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(31,'20260503-0000114','2550.00','admin','2026 05 03','  Cash','  General','2550.00','0.00','0.00','0.0','_31','202605030731',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(32,'20260503-0000115','550.00','admin','2026 05 03','  Cash','  General','550.00','0.00','0.00','0.0','_32','202605030733',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(33,'20260503-0000116','807.40','admin','2026 05 03','  Cash','  General','807.40','0.00','0.00','0.0','_33','202605030735',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(34,'20260503-0000117','580.00','admin','2026 05 03','  Cash','  General','580.00','0.00','0.00','0.0','_34','202605030745',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(35,'20260503-0000118','1618.40','admin','2026 05 03','  Cash','  General','1618.40','0.00','0.00','0.0','_35','202605030747',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(36,'20260503-0000119','918.00','admin','2026 05 03','  Cash','  General','918.00','0.00','0.00','0.0','_36','202605030754',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(37,'20260503-0000120','178.84','admin','2026 05 03','  Cash','  General','178.84','0.00','0.00','0.0','_37','202605030755',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(38,'20260503-0000121','550.00','admin','2026 05 03','  Cash','  General','550.00','0.00','0.00','0.0','_38','202605030756',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(39,'20260503-0000122','550.00','admin','2026 05 03','  Cash','  General','550.00','0.00','0.00','0.0','_39','202605030803',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(40,'20260503-0000123','870.00','admin','2026 05 03','  Cash','  General','870.00','0.00','0.00','0.0','_40','202605030807',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(41,'20260503-0000124','240.00','admin','2026 05 03','  Cash','  General','240.00','0.00','0.00','0.0','_41','202605030817',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(42,'20260503-0000125','580.00','admin','2026 05 03','  Cash','  General','580.00','0.00','0.00','0.0','_42','202605030833',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(43,'20260503-0000126','518.40','admin','2026 05 03','  Cash','  General','518.40','0.00','0.00','0.0','_43','202605030834',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(44,'20260503-0000127','840.00','admin','2026 05 03','  Cash','  General','840.00','0.00','0.00','0.0','_44','202605030836',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(45,'20260503-0000128','288.00','admin','2026 05 03','  Cash','  General','288.00','0.00','0.00','0.0','_45','202605030900',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(46,'20260503-0000129','400.00','admin','2026 05 03','  Cash','  General','400.00','0.00','0.00','0.0','_46','202605030905',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(47,'20260503-0000130','1000.50','admin','2026 05 03','  Cash','  General','1000.50','0.00','0.00','0.0','_47','202605030913',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(48,'20260503-0000131','464.00','admin','2026 05 03','  Cash','  General','464.00','0.00','0.00','0.0','_48','202605030923',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(49,'20260503-0000132','1042.40','admin','2026 05 03','  Cash','  General','1042.40','0.00','0.00','0.0','_49','202605030926',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(50,'20260503-0000133','660.00','admin','2026 05 03','  Cash','  General','660.00','0.00','0.00','0.0','_50','202605030928',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(51,'20260503-0000134','396.00','admin','2026 05 03','  Cash','  General','396.00','0.00','0.00','0.0','_51','202605030935',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(52,'20260503-0000135','406.00','admin','2026 05 03','  Cash','  General','406.00','0.00','0.00','0.0','_52','202605030940',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(53,'20260503-0000136','702.10','admin','2026 05 03','  Cash','  General','702.10','0.00','0.00','0.0','_53','202605030945',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(54,'20260503-0000137','350.00','admin','2026 05 03','  Cash','  General','350.00','0.00','0.00','0.0','_54','202605030951',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(55,'20260503-0000138','371.20','admin','2026 05 03','  Cash','  General','371.20','0.00','0.00','0.0','_55','202605031003',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(56,'20260503-0000139','461.60','admin','2026 05 03','  Cash','  General','461.60','0.00','0.00','0.0','_56','202605031013',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(57,'20260503-0000140','302.40','admin','2026 05 03','  Cash','  General','302.40','0.00','0.00','0.0','_57','202605031025',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(58,'20260503-0000141','312.00','admin','2026 05 03','  Cash','  General','312.00','0.00','0.00','0.0','_58','202605031028',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(59,'20260503-0000142','488.00','admin','2026 05 03','  Cash','  General','488.00','0.00','0.00','0.0','_59','202605031033',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(60,'20260503-0000143','428.00','admin','2026 05 03','  Cash','  General','428.00','0.00','0.00','0.0','_60','202605031043',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(61,'20260503-0000144','489.80','admin','2026 05 03','  Cash','  General','489.80','0.00','0.00','0.0','_61','202605031103',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(62,'20260503-0000145','435.00','admin','2026 05 03','  Cash','  General','435.00','0.00','0.00','0.0','_62','202605031215',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'mathi',320),(2,'white eral',580);
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,'1600','mathi',320,36,'1','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1601','white eral',580,64,'1','dals and pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (6,'dals and pulses',900);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',900);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',900,100);
