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,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000011','09:06:59 am','2024 06 18','admin','1','  General','  Cash','280.00','280.00','3',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061809:06:59','%','0','280.00','no','0.00',NULL,'202406180906','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'20:20:0:13','1.0','1160.00','1160.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','4',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','1160.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','5',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','280.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,' satareta','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','6',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','550.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'MOP','1.0','1750.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','7',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','1750.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'16:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','8',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','1150.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,' KME:1LT','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000012','10:44:45 pm','2024 06 18','admin','1','  General','  Card','6090.00','6090.00','9',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:44:45','%','0','1200.00','no','0.00',NULL,'202406182244','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'20:20:0:13','1.0','1160.00','1160.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000013','10:47:09 pm','2024 06 18','admin','1','  General','  Cash','1990.00','1990.00','10',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:09','%','0','1160.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000013','10:47:09 pm','2024 06 18','admin','1','  General','  Cash','1990.00','1990.00','11',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:09','%','0','280.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,' satareta','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000013','10:47:09 pm','2024 06 18','admin','1','  General','  Cash','1990.00','1990.00','12',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:09','%','0','550.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,' KME:1LT','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000014','10:47:25 pm','2024 06 18','admin','1','  General','  Cash','2630.00','2630.00','13',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:25','%','0','1200.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'16:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000014','10:47:25 pm','2024 06 18','admin','1','  General','  Cash','2630.00','2630.00','14',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:25','%','0','1150.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240618-000014','10:47:25 pm','2024 06 18','admin','1','  General','  Cash','2630.00','2630.00','15',NULL,NULL,NULL,NULL,'18 Jun 2024','2024061822:47:25','%','0','280.00','no','0.00',NULL,'202406182247','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','22',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','1360.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','23',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','1150.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','24',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','280.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,' satareta','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','25',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','550.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,' KME:1LT','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','26',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','1200.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'16:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000011','03:24:55 pm','2024 07 08','admin','1','  General','  Upiqr','5690.00','5690.00','27',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:24:55','%','0','1150.00','no','0.00',NULL,'202407081524','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','03:42:08 pm','2024 07 08','admin','1','  General','  Cash','4880.00','4880.00','29',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:08','%','0','1150.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','03:42:08 pm','2024 07 08','admin','1','  General','  Cash','4880.00','4880.00','30',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:08','%','0','280.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,' satareta','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','03:42:08 pm','2024 07 08','admin','1','  General','  Cash','4880.00','4880.00','31',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:08','%','0','550.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'MOP','1.0','1750.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','03:42:08 pm','2024 07 08','admin','1','  General','  Cash','4880.00','4880.00','32',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:08','%','0','1750.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'16:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000012','03:42:08 pm','2024 07 08','admin','1','  General','  Cash','4880.00','4880.00','33',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:08','%','0','1150.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'20:20:0:13','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','03:42:34 pm','2024 07 08','admin','1','  General','  Cash','2860.00','2860.00','34',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:34','%','0','2300.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'uraya ','2.0','280.00','560.00','Item',NULL,NULL,'no',NULL,NULL,'20240708-000013','03:42:34 pm','2024 07 08','admin','1','  General','  Cash','2860.00','2860.00','35',NULL,NULL,NULL,NULL,'08 Jul 2024','2024070815:42:34','%','0','560.00','no','0.00',NULL,'202407081542','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','10:36:30 am','2024 07 11','admin','1','  General','  Cash','2510.00','2510.00','36',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071110:36:30','%','0','1150.00','no','0.00',NULL,'202407111036','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000011','10:36:30 am','2024 07 11','admin','1','  General','  Cash','2510.00','2510.00','37',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071110:36:30','%','0','1360.00','no','0.00',NULL,'202407111036','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'20:20:0:13','12','1150.00','13800.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000012','10:37:04 am','2024 07 11','admin','1','  General','  Cash','16040.00','16040.00','38',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071110:37:04','%','0','1150.00','no','0.00',NULL,'202407111037','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'uraya ','8','280.00','2240.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000012','10:37:04 am','2024 07 11','admin','1','  General','  Cash','16040.00','16040.00','39',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071110:37:04','%','0','280.00','no','0.00',NULL,'202407111037','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'MOP','1.0','1750.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20240711-000013','11:44:15 pm','2024 07 11','admin','1','  General','  Cash','1750.00','1750.00','40',NULL,NULL,NULL,NULL,'11 Jul 2024','2024071123:44:15','%','0','1750.00','no','0.00',NULL,'202407112344','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','03:00:52 pm','2024 07 12','admin','1','  General','  Cash','1430.00','1430.00','45',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:00:52','%','0','1150.00','no','0.00',NULL,'202407121500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000011','03:00:52 pm','2024 07 12','admin','1','  General','  Cash','1430.00','1430.00','46',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:00:52','%','0','280.00','no','0.00',NULL,'202407121500','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'COUNCIL: ACTIV','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','47',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','1200.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','48',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','1360.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'PARRYFOS:1LT','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','49',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','550.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'SAFAL. A:1LT','1.0','600.00','600.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','50',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','600.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'VEER:500ML','1.0','780.00','780.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','51',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','780.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'Veer:1LT','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000012','03:01:11 pm','2024 07 12','admin','1','  General','  Cash','5990.00','5990.00','52',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:01:11','%','0','1500.00','no','0.00',NULL,'202407121501','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'uraya ','10','280.00','2800.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000013','03:59:41 pm','2024 07 12','admin','1','  General','  Cash','16400.00','16400.00','53',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:59:41','%','0','280.00','no','0.00',NULL,'202407121559','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'DAP','10','1360.00','13600.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000013','03:59:41 pm','2024 07 12','admin','1','  General','  Cash','16400.00','16400.00','54',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071215:59:41','%','0','1360.00','no','0.00',NULL,'202407121559','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'KAPENI:1KG','4','600.00','2400.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000014','04:02:08 pm','2024 07 12','admin','1','  General','  Cash','5730.00','5730.00','55',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:02:08','%','0','600.00','no','0.00',NULL,'202407121602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'KAPENI:500GRM','2','290.00','580.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000014','04:02:08 pm','2024 07 12','admin','1','  General','  Cash','5730.00','5730.00','56',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:02:08','%','0','290.00','no','0.00',NULL,'202407121602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'PARRYFOS:1LT','5','550.00','2750.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000014','04:02:08 pm','2024 07 12','admin','1','  General','  Cash','5730.00','5730.00','57',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:02:08','%','0','1100.00','no','0.00',NULL,'202407121602','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'20:20:0:13','4','1150.00','4600.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000015','04:03:30 pm','2024 07 12','admin','1','  General','  Cash','7880.00','7880.00','58',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:03:30','%','0','1150.00','no','0.00',NULL,'202407121603','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'DAP','2','1360.00','2720.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000015','04:03:30 pm','2024 07 12','admin','1','  General','  Cash','7880.00','7880.00','59',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:03:30','%','0','1360.00','no','0.00',NULL,'202407121603','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'uraya ','2','280.00','560.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000015','04:03:30 pm','2024 07 12','admin','1','  General','  Cash','7880.00','7880.00','60',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:03:30','%','0','280.00','no','0.00',NULL,'202407121603','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000016','04:04:23 pm','2024 07 12','admin','1','  General','  Cash','3070.00','3070.00','61',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:04:23','%','0','1150.00','no','0.00',NULL,'202407121604','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'uraya ','2.0','280.00','560.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000016','04:04:23 pm','2024 07 12','admin','1','  General','  Cash','3070.00','3070.00','62',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:04:23','%','0','560.00','no','0.00',NULL,'202407121604','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000016','04:04:23 pm','2024 07 12','admin','1','  General','  Cash','3070.00','3070.00','63',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:04:23','%','0','1360.00','no','0.00',NULL,'202407121604','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'KRIFOS:500ML','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000017','04:05:29 pm','2024 07 12','admin','1','  General','  Cash','570.00','570.00','64',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:05:29','%','0','350.00','no','0.00',NULL,'202407121605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'THIOGUARD:25WG:100GRM','1.0','220.00','220.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000017','04:05:29 pm','2024 07 12','admin','1','  General','  Cash','570.00','570.00','65',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:05:29','%','0','220.00','no','0.00',NULL,'202407121605','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'PARRYFOS:500ML','1.0','300.00','300.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000018','04:06:13 pm','2024 07 12','admin','1','  General','  Cash','520.00','520.00','66',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:06:13','%','0','300.00','no','0.00',NULL,'202407121606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'THIOGUARD:25WG:100GRM','1.0','220.00','220.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000018','04:06:13 pm','2024 07 12','admin','1','  General','  Cash','520.00','520.00','67',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:06:13','%','0','220.00','no','0.00',NULL,'202407121606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'20:20:0:13','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000019','04:06:55 pm','2024 07 12','admin','1','  General','  Cash','4500.00','4500.00','68',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:06:55','%','0','2300.00','no','0.00',NULL,'202407121606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000019','04:06:55 pm','2024 07 12','admin','1','  General','  Cash','4500.00','4500.00','69',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:06:55','%','0','1360.00','no','0.00',NULL,'202407121606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'uraya ','3.0','280.00','840.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-000019','04:06:55 pm','2024 07 12','admin','1','  General','  Cash','4500.00','4500.00','70',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:06:55','%','0','840.00','no','0.00',NULL,'202407121606','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'uraya ','3.0','280.00','840.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000110','04:07:28 pm','2024 07 12','admin','1','  General','  Cash','3140.00','3140.00','71',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:07:28','%','0','840.00','no','0.00',NULL,'202407121607','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'20:20:0:13','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000110','04:07:28 pm','2024 07 12','admin','1','  General','  Cash','3140.00','3140.00','72',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:07:28','%','0','2300.00','no','0.00',NULL,'202407121607','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'Veer:1LT','1.0','1500.00','1500.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000111','04:30:32 pm','2024 07 12','admin','1','  General','  Cash','2830.00','2830.00','74',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:32','%','0','1500.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'VEER:500ML','1.0','780.00','780.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000111','04:30:32 pm','2024 07 12','admin','1','  General','  Cash','2830.00','2830.00','75',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:32','%','0','780.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'PARRYFOS:1LT','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000111','04:30:32 pm','2024 07 12','admin','1','  General','  Cash','2830.00','2830.00','76',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:32','%','0','550.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'DAP','1.0','1360.00','1360.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','77',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','1360.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','78',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','280.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'20:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','79',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','1150.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'16:20:0:13','1.0','1150.00','1150.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','80',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','1150.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,' KME:1LT','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','81',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','1200.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'satareta','1.0','550.00','550.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000114','04:30:57 pm','2024 07 12','admin','1','  General','  Cash','5690.00','5690.00','82',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:30:57','%','0','550.00','no','0.00',NULL,'202407121630','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'uraya ','1.0','280.00','280.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000115','04:31:54 pm','2024 07 12','admin','1','  General','  Cash','1480.00','1480.00','83',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:31:54','%','0','280.00','no','0.00',NULL,'202407121631','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,' KME:1LT','1.0','1200.00','1200.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000115','04:31:54 pm','2024 07 12','admin','1','  General','  Cash','1480.00','1480.00','84',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:31:54','%','0','1200.00','no','0.00',NULL,'202407121631','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'FORNAX/FORAJAN:150Ml','1.0','1750.00','1750.00','Item',NULL,NULL,'no',NULL,NULL,'20240712-0000116','04:50:48 pm','2024 07 12','admin','1','  General','  Cash','1750.00','1750.00','85',NULL,NULL,NULL,NULL,'12 Jul 2024','2024071216:50:48','%','0','1750.00','no','0.00',NULL,'202407121650','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(72,'DAP','2.0','1360.00','2720.00','Item',NULL,NULL,'no',NULL,NULL,'20240713-000011','07:45:04 am','2024 07 13','admin','1','  General','  Cash','5860.00','5860.00','86',NULL,NULL,NULL,NULL,'13 Jul 2024','2024071307:45:04','%','0','2720.00','no','0.00',NULL,'202407130745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(73,'20:20:0:13','2.0','1150.00','2300.00','Item',NULL,NULL,'no',NULL,NULL,'20240713-000011','07:45:04 am','2024 07 13','admin','1','  General','  Cash','5860.00','5860.00','87',NULL,NULL,NULL,NULL,'13 Jul 2024','2024071307:45:04','%','0','2300.00','no','0.00',NULL,'202407130745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(74,'uraya ','3.0','280.00','840.00','Item',NULL,NULL,'no',NULL,NULL,'20240713-000011','07:45:04 am','2024 07 13','admin','1','  General','  Cash','5860.00','5860.00','88',NULL,NULL,NULL,NULL,'13 Jul 2024','2024071307:45:04','%','0','840.00','no','0.00',NULL,'202407130745','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','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,'20240618-000011','280.00','admin','2024 06 18','  Cash','  General','280.00','0.00','0.00','0.0','1','202406180906',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240618-000012','6090.00','admin','2024 06 18','  Card','  General','6090.00','0.00','0.00','0.0','2','202406182244',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240618-000013','1990.00','admin','2024 06 18','  Cash','  General','1990.00','0.00','0.00','0.0','3','202406182247',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240618-000014','2630.00','admin','2024 06 18','  Cash','  General','2630.00','0.00','0.00','0.0','4','202406182247',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240708-000011','5690.00','admin','2024 07 08','  Upiqr','  General','5690.00','0.00','0.00','0.0','5','202407081524',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240708-000012','4880.00','admin','2024 07 08','  Cash','  General','4880.00','0.00','0.00','0.0','6','202407081542',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240708-000013','2860.00','admin','2024 07 08','  Cash','  General','2860.00','0.00','0.00','0.0','7','202407081542',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240711-000011','2510.00','admin','2024 07 11','  Cash','  General','2510.00','0.00','0.00','0.0','8','202407111036',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240711-000012','16040.00','admin','2024 07 11','  Cash','  General','16040.00','0.00','0.00','0.0','9','202407111037',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20240711-000013','1750.00','admin','2024 07 11','  Cash','  General','1750.00','0.00','0.00','0.0','10','202407112344',NULL,NULL,NULL,NULL,NULL,NULL),(11,'20240712-000011','1430.00','admin','2024 07 12','  Cash','  General','1430.00','0.00','0.00','0.0','11','202407121500',NULL,NULL,NULL,NULL,NULL,NULL),(12,'20240712-000012','5990.00','admin','2024 07 12','  Cash','  General','5990.00','0.00','0.00','0.0','12','202407121501',NULL,NULL,NULL,NULL,NULL,NULL),(13,'20240712-000013','16400.00','admin','2024 07 12','  Cash','  General','16400.00','0.00','0.00','0.0','13','202407121559',NULL,NULL,NULL,NULL,NULL,NULL),(14,'20240712-000014','5730.00','admin','2024 07 12','  Cash','  General','5730.00','0.00','0.00','0.0','14','202407121602',NULL,NULL,NULL,NULL,NULL,NULL),(15,'20240712-000015','7880.00','admin','2024 07 12','  Cash','  General','7880.00','0.00','0.00','0.0','15','202407121603',NULL,NULL,NULL,NULL,NULL,NULL),(16,'20240712-000016','3070.00','admin','2024 07 12','  Cash','  General','3070.00','0.00','0.00','0.0','16','202407121604',NULL,NULL,NULL,NULL,NULL,NULL),(17,'20240712-000017','570.00','admin','2024 07 12','  Cash','  General','570.00','0.00','0.00','0.0','17','202407121605',NULL,NULL,NULL,NULL,NULL,NULL),(18,'20240712-000018','520.00','admin','2024 07 12','  Cash','  General','520.00','0.00','0.00','0.0','18','202407121606',NULL,NULL,NULL,NULL,NULL,NULL),(19,'20240712-000019','4500.00','admin','2024 07 12','  Cash','  General','4500.00','0.00','0.00','0.0','19','202407121606',NULL,NULL,NULL,NULL,NULL,NULL),(20,'20240712-0000110','3140.00','admin','2024 07 12','  Cash','  General','3140.00','0.00','0.00','0.0','20','202407121607',NULL,NULL,NULL,NULL,NULL,NULL),(21,'20240712-0000111','2830.00','admin','2024 07 12','  Cash','  General','2830.00','0.00','0.00','0.0','21','202407121630',NULL,NULL,NULL,NULL,NULL,NULL),(22,'20240712-0000111','2830.00','admin','2024 07 12','  Cash','  General','2830.00','0','0.00','0.0','22','202407121630',NULL,NULL,NULL,NULL,NULL,NULL),(23,'20240712-0000111','2830.00','admin','2024 07 12','  Cash','  General','2830.00','0','0.00','0.0','23','202407121630',NULL,NULL,NULL,NULL,NULL,NULL),(24,'20240712-0000114','5690.00','admin','2024 07 12','  Cash','  General','5690.00','0.00','0.00','0.0','24','202407121630',NULL,NULL,NULL,NULL,NULL,NULL),(25,'20240712-0000115','1480.00','admin','2024 07 12','  Cash','  General','1480.00','0.00','0.00','0.0','25','202407121631',NULL,NULL,NULL,NULL,NULL,NULL),(26,'20240712-0000116','1750.00','admin','2024 07 12','  Cash','  General','1750.00','0.00','0.00','0.0','26','202407121650',NULL,NULL,NULL,NULL,NULL,NULL),(27,'20240713-000011','5860.00','admin','2024 07 13','  Cash','  General','5860.00','0.00','0.00','0.0','27','202407130745',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
