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,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20251222-000011','03:00:03 PM','2025 12 22','admin','1','  General','  Upiqr','20.00','20.00','1',NULL,NULL,NULL,NULL,'22 Dec 2025','2025122215:00:03','%','0','60.00','no','0.00',NULL,'202512221500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(2,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20251222-000012','04:12:23 PM','2025 12 22','admin','1','  General','  Upiqr','20.00','20.00','2',NULL,NULL,NULL,NULL,'22 Dec 2025','2025122216:12:23','%','0','20.00','no','0.00',NULL,'202512221612',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(3,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20251222-000013','04:30:23 PM','2025 12 22','admin','1','  General','  Upiqr','40.00','40.00','3',NULL,NULL,NULL,NULL,'22 Dec 2025','2025122216:30:23','%','0','40.00','no','0.00',NULL,'202512221630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(4,'SENIOR CITIZEN','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20251222-000014','06:43:08 PM','2025 12 22','admin','1','  General','  Upiqr','10.00','10.00','1',NULL,NULL,NULL,NULL,'22 Dec 2025','2025122218:43:08','%','0','10.00','no','0.00',NULL,'202512221843',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(5,'SENIOR CITIZEN','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20251222-000015','07:20:50 PM','2025 12 22','admin','1','  General','  Upiqr','10.00','10.00','2',NULL,NULL,NULL,NULL,'22 Dec 2025','2025122219:20:50','%','0','10.00','no','0.00',NULL,'202512221920',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(6,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20251230-000011','04:30:11 PM','2025 12 30','admin','1','  General','  Cash','10.00','10.00','3',NULL,NULL,NULL,NULL,'30 Dec 2025','2025123016:30:11','%','0','10.00','no','0.00',NULL,'202512301630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(7,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260101-000011','07:02:03 PM','2026 01 01','admin','1','  General','  Cash','10.00','10.00','7',NULL,NULL,NULL,NULL,'01 Jan 2026','2026010119:02:03','%','0','10.00','no','0.00',NULL,'202601011902',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(8,'SENIOR CITIZEN','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000011','10:22:01 AM','2026 01 02','admin','1','  General','  Cash','30.00','30.00','9',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:22:01','%','0','10.00','no','0.00',NULL,'202601021022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(9,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000011','10:22:01 AM','2026 01 02','admin','1','  General','  Cash','30.00','30.00','10',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:22:01','%','0','20.00','no','0.00',NULL,'202601021022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(10,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000012','10:26:50 AM','2026 01 02','admin','1','  General','  Cash','10.00','10.00','12',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:26:50','%','0','10.00','no','0.00',NULL,'202601021026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(11,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000013','10:35:11 AM','2026 01 02','admin','1','  General','  Cash','90.00','90.00','13',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:35:11','%','0','80.00','no','0.00',NULL,'202601021035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(12,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000013','10:35:11 AM','2026 01 02','admin','1','  General','  Cash','90.00','90.00','14',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:35:11','%','0','10.00','no','0.00',NULL,'202601021035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(13,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260102-000014','10:43:12 AM','2026 01 02','admin','1','  General','  Cash','10.00','10.00','15',NULL,NULL,NULL,NULL,'02 Jan 2026','2026010210:43:12','%','0','10.00','no','0.00',NULL,'202601021043',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(14,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000011','04:04:15 PM','2026 01 27','admin','1','  General','  Cash','20.00','20.00','22',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012716:04:15','%','0','20.00','no','0.00',NULL,'202601271604',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(15,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000012','04:13:22 PM','2026 01 27','admin','1','  General','  Cash','60.00','60.00','23',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012716:13:22','%','0','60.00','no','0.00',NULL,'202601271613',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(16,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000013','04:31:30 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','24',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012716:31:30','%','0','40.00','no','0.00',NULL,'202601271631',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(17,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000014','05:25:03 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','28',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012717:25:03','%','0','40.00','no','0.00',NULL,'202601271725',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(18,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000015','05:35:57 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','29',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012717:35:57','%','0','80.00','no','0.00',NULL,'202601271735',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(19,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000016','05:36:58 PM','2026 01 27','admin','1','  General','  Cash','20.00','20.00','30',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012717:36:58','%','0','20.00','no','0.00',NULL,'202601271736',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(20,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000017','05:41:54 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','31',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012717:41:54','%','0','40.00','no','0.00',NULL,'202601271741',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(21,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000018','05:49:05 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','32',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012717:49:05','%','0','40.00','no','0.00',NULL,'202601271749',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(22,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000019','06:00:35 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','33',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:00:35','%','0','60.00','no','0.00',NULL,'202601271800',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(23,'CHILD','3.0','10.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-000019','06:00:35 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','34',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:00:35','%','0','30.00','no','0.00',NULL,'202601271800',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'10.00'),(24,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000110','06:02:19 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','35',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:02:19','%','0','40.00','no','0.00',NULL,'202601271802',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(25,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000111','06:06:00 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','36',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:06:00','%','0','80.00','no','0.00',NULL,'202601271806',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(26,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000112','06:07:42 PM','2026 01 27','admin','1','  General','  Cash','60.00','60.00','37',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:07:42','%','0','60.00','no','0.00',NULL,'202601271807',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(27,'ADULT','6.0','20.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000113','06:20:37 PM','2026 01 27','admin','1','  General','  Cash','120.00','120.00','38',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:20:37','%','0','120.00','no','0.00',NULL,'202601271820',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'120.00','','','','',NULL,'20.00'),(28,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000114','06:23:17 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','39',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:23:17','%','0','80.00','no','0.00',NULL,'202601271823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(29,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000114','06:23:17 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','40',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:23:17','%','0','10.00','no','0.00',NULL,'202601271823',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(30,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000115','06:30:16 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','41',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:30:16','%','0','40.00','no','0.00',NULL,'202601271830',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(31,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000116','06:30:36 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','42',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:30:36','%','0','40.00','no','0.00',NULL,'202601271830',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(32,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000117','06:38:56 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','43',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:38:56','%','0','60.00','no','0.00',NULL,'202601271838',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(33,'CHILD','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000117','06:38:56 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','44',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:38:56','%','0','20.00','no','0.00',NULL,'202601271838',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(34,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000118','06:45:53 PM','2026 01 27','admin','1','  General','  Cash','20.00','20.00','45',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:45:53','%','0','20.00','no','0.00',NULL,'202601271845',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(35,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000119','06:48:08 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','47',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:48:08','%','0','40.00','no','0.00',NULL,'202601271848',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(36,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000120','06:56:07 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','52',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012718:56:07','%','0','40.00','no','0.00',NULL,'202601271856',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(37,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000121','07:00:40 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','53',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:00:40','%','0','60.00','no','0.00',NULL,'202601271900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(38,'CHILD','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000121','07:00:40 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','54',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:00:40','%','0','20.00','no','0.00',NULL,'202601271900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'10.00'),(39,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000122','07:02:29 PM','2026 01 27','admin','1','  General','  Cash','20.00','20.00','55',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:02:29','%','0','20.00','no','0.00',NULL,'202601271902',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(40,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000123','07:02:49 PM','2026 01 27','admin','1','  General','  Cash','20.00','20.00','56',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:02:49','%','0','20.00','no','0.00',NULL,'202601271902',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(41,'ADULT','5.0','20.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000124','07:09:07 PM','2026 01 27','admin','1','  General','  Cash','100.00','100.00','57',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:09:07','%','0','100.00','no','0.00',NULL,'202601271909',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'20.00'),(42,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000125','07:12:16 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','58',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:12:16','%','0','80.00','no','0.00',NULL,'202601271912',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(43,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000126','07:19:20 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','59',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:19:20','%','0','40.00','no','0.00',NULL,'202601271919',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(44,'ADULT','5.0','20.00','100.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000127','07:22:25 PM','2026 01 27','admin','1','  General','  Cash','110.00','110.00','62',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:22:25','%','0','100.00','no','0.00',NULL,'202601271922',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'100.00','','','','',NULL,'20.00'),(45,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000127','07:22:25 PM','2026 01 27','admin','1','  General','  Cash','110.00','110.00','63',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:22:25','%','0','10.00','no','0.00',NULL,'202601271922',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(46,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000128','07:22:35 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','64',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:22:35','%','0','40.00','no','0.00',NULL,'202601271922',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(47,'ADULT','3.0','20.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000129','07:24:38 PM','2026 01 27','admin','1','  General','  Cash','60.00','60.00','65',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:24:38','%','0','60.00','no','0.00',NULL,'202601271924',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'60.00','','','','',NULL,'20.00'),(48,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000130','07:28:37 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','66',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012719:28:37','%','0','40.00','no','0.00',NULL,'202601271928',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(49,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000131','08:09:39 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','67',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012720:09:39','%','0','40.00','no','0.00',NULL,'202601272009',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(50,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000132','08:10:02 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','68',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012720:10:02','%','0','40.00','no','0.00',NULL,'202601272010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(51,'ADULT','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000133','08:25:44 PM','2026 01 27','admin','1','  General','  Cash','40.00','40.00','69',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012720:25:44','%','0','40.00','no','0.00',NULL,'202601272025',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(52,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000134','08:44:16 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','70',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012720:44:16','%','0','80.00','no','0.00',NULL,'202601272044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(53,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000134','08:44:16 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','71',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012720:44:16','%','0','10.00','no','0.00',NULL,'202601272044',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(54,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000135','09:01:36 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','73',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012721:01:36','%','0','80.00','no','0.00',NULL,'202601272101',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(55,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000135','09:01:36 PM','2026 01 27','admin','1','  General','  Cash','90.00','90.00','74',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012721:01:36','%','0','10.00','no','0.00',NULL,'202601272101',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(56,'ADULT','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20260127-0000136','09:17:45 PM','2026 01 27','admin','1','  General','  Cash','80.00','80.00','75',NULL,NULL,NULL,NULL,'27 Jan 2026','2026012721:17:45','%','0','80.00','no','0.00',NULL,'202601272117',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'80.00','','','','',NULL,'20.00'),(57,'ADULT','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20260128-000011','08:46:42 AM','2026 01 28','admin','1','  General','  Cash','20.00','20.00','78',NULL,NULL,NULL,NULL,'28 Jan 2026','2026012808:46:42','%','0','20.00','no','0.00',NULL,'202601280846',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'20.00','','','','',NULL,'20.00'),(58,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'11529-20260128-000012','02:20:30 PM','2026 01 28','admin','1','  General','  Upiqr','10.00','10.00','86',NULL,NULL,NULL,NULL,'28 Jan 2026','2026012814:20:30','%','0','10.00','no','0.00',NULL,'202601281420',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin','0',NULL,'',NULL,'10.00','','','','',NULL,'10.00'),(59,'CHILD','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'11529-20260219-000011','03:17:01 PM','2026 02 19','admin','1','  General','  Cash','10.00','10.00','87',NULL,NULL,NULL,NULL,'19 Feb 2026','2026021915:17:01','%','0','10.00','no','0.00',NULL,'202602191517',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','admin','madmin',NULL,NULL,'',NULL,'10.00','','','','',NULL,'10.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,'20251222-000011','20.00','admin','2025 12 22','  Upiqr','  General','20.00','0.00','0.00','0.0','1','202512221500',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(2,'20251222-000012','20.00','admin','2025 12 22','  Upiqr','  General','20.00','0.00','0.00','0.0','2','202512221612',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(3,'20251222-000013','40.00','admin','2025 12 22','  Upiqr','  General','40.00','0.00','0.00','0.0','3','202512221630',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(4,'20251222-000014','10.00','admin','2025 12 22','  Upiqr','  General','10.00','0.00','0.00','0.0','4','202512221843',NULL,NULL,NULL,NULL,NULL,NULL,'572286797978',NULL,NULL,'mswipe'),(5,'20251222-000015','10.00','admin','2025 12 22','  Upiqr','  General','10.00','0.00','0.00','0.0','5','202512221920',NULL,NULL,NULL,NULL,NULL,NULL,'535644749819',NULL,NULL,'mswipe'),(6,'20251230-000011','10.00','admin','2025 12 30','  Cash','  General','10.00','0.00','0.00','0.0','6','202512301630',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(7,'20260101-000011','10.00','admin','2026 01 01','  Cash','  General','10.00','0.00','0.00','0.0','7','202601011902',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(8,'20260102-000011','30.00','admin','2026 01 02','  Cash','  General','30.00','0.00','0.00','0.0','8','202601021022',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(9,'20260102-000012','10.00','admin','2026 01 02','  Cash','  General','10.00','0.00','0.00','0.0','9','202601021026',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(10,'20260102-000013','90.00','admin','2026 01 02','  Cash','  General','90.00','0.00','0.00','0.0','10','202601021035',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(11,'20260102-000014','10.00','admin','2026 01 02','  Cash','  General','10.00','0.00','0.00','0.0','11','202601021043',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(12,'20260127-000011','20.00','admin','2026 01 27','  Cash','  General','20.00','0.00','0.00','0.0','12','202601271604',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(13,'20260127-000012','60.00','admin','2026 01 27','  Cash','  General','60.00','0.00','0.00','0.0','13','202601271613',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(14,'20260127-000013','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','14','202601271631',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(15,'20260127-000014','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','15','202601271725',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(16,'20260127-000015','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','16','202601271735',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(17,'20260127-000016','20.00','admin','2026 01 27','  Cash','  General','20.00','0.00','0.00','0.0','17','202601271736',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(18,'20260127-000017','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','18','202601271741',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(19,'20260127-000018','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','19','202601271749',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(20,'20260127-000019','90.00','admin','2026 01 27','  Cash','  General','90.00','0.00','0.00','0.0','20','202601271800',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(21,'20260127-0000110','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','21','202601271802',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(22,'20260127-0000111','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','22','202601271806',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(23,'20260127-0000112','60.00','admin','2026 01 27','  Cash','  General','60.00','0.00','0.00','0.0','23','202601271807',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(24,'20260127-0000113','120.00','admin','2026 01 27','  Cash','  General','120.00','0.00','0.00','0.0','24','202601271820',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(25,'20260127-0000114','90.00','admin','2026 01 27','  Cash','  General','90.00','0.00','0.00','0.0','25','202601271823',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(26,'20260127-0000115','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','26','202601271830',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(27,'20260127-0000116','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','27','202601271830',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(28,'20260127-0000117','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','28','202601271838',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(29,'20260127-0000118','20.00','admin','2026 01 27','  Cash','  General','20.00','0.00','0.00','0.0','29','202601271845',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(30,'20260127-0000119','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','30','202601271848',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(31,'20260127-0000120','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','31','202601271856',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(32,'20260127-0000121','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','32','202601271900',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(33,'20260127-0000122','20.00','admin','2026 01 27','  Cash','  General','20.00','0.00','0.00','0.0','33','202601271902',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(34,'20260127-0000123','20.00','admin','2026 01 27','  Cash','  General','20.00','0.00','0.00','0.0','34','202601271902',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(35,'20260127-0000124','100.00','admin','2026 01 27','  Cash','  General','100.00','0.00','0.00','0.0','35','202601271909',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(36,'20260127-0000125','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','36','202601271912',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(37,'20260127-0000126','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','37','202601271919',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(38,'20260127-0000127','110.00','admin','2026 01 27','  Cash','  General','110.00','0.00','0.00','0.0','38','202601271922',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(39,'20260127-0000128','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','39','202601271922',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(40,'20260127-0000129','60.00','admin','2026 01 27','  Cash','  General','60.00','0.00','0.00','0.0','40','202601271924',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(41,'20260127-0000130','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','41','202601271928',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(42,'20260127-0000131','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','42','202601272009',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(43,'20260127-0000132','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','43','202601272010',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(44,'20260127-0000133','40.00','admin','2026 01 27','  Cash','  General','40.00','0.00','0.00','0.0','44','202601272025',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(45,'20260127-0000134','90.00','admin','2026 01 27','  Cash','  General','90.00','0.00','0.00','0.0','45','202601272044',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(46,'20260127-0000135','90.00','admin','2026 01 27','  Cash','  General','90.00','0.00','0.00','0.0','46','202601272101',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(47,'20260127-0000136','80.00','admin','2026 01 27','  Cash','  General','80.00','0.00','0.00','0.0','47','202601272117',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,''),(48,'20260128-000011','20.00','admin','2026 01 28','  Cash','  General','20.00','0.00','0.00','0.0','48','202601280846',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,'ADULT',80),(2,'SENIOR CITIZEN',10);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'None',2050,100,'108');
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,'1','ADULT',80,89,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'3','SENIOR CITIZEN',10,11,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (3,'None',90),(4,'None',90),(5,'None',100),(30,'None',20),(31,'None',20),(33,'None',30),(40,'None',30);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',90);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',90,100);
