INSERT INTO `test_values` (`id`, `test_type_id`, `test_id`, `value_heading_id`, `name`, `left_result`, `right_result`, `ref_range`, `value`, `type`, `width`, `table_header`, `rank`, `created_at`, `updated_at`, `description`) VALUES
(844, 1252, 42, NULL, 'Pregnancy profile-anencephaly', NULL, NULL, NULL, NULL, 5, NULL, NULL, 9, '2024-06-27 00:38:07', '2024-06-27 00:41:29', '<div class=\"content\" style=\"background-color: #fff; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; max-height: 600px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 15px;\">\r\n<div style=\"text-align: center; font-size: 18px; border: 0px dotted #000; padding: 10px; margin-bottom: 20px;\">\r\n<div style=\"text-align: center; font-size: 18px; border: 1px dotted #000; padding: 10px; margin-bottom: 20px;\"><strong><u>USG OF LOWER ABDOMEN</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 15px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Uterus</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Gravid</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Number of Fetus</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Single</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Fetal Movement and Cardiac Pulsation</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Present. FHR-143 beats/min</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>AC</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">14.11 cm</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>BPD</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Could not be measured, vault is absent</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>FL</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">3.13 cm</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Placenta</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Anterior</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Amniotic Fluid</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Adequate</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Presentation</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Cephalic at present</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Gestational Age</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">18+ weeks</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>EFW (approx)</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">272 gm</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>EDD (machine)</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">16/10/2017 &plusmn; 7 days</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 46.6925%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong><u>Comment</u></strong></th>\r\n<td style=\"width: 50.3075%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Single alive fetus of 18+ weeks of gestation with anencephaly.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>'),
(845, 1252, 42, NULL, 'USG Pregnancy - IUD', NULL, NULL, NULL, NULL, 5, NULL, NULL, 10, '2024-06-27 00:46:15', '2024-06-27 00:46:37', '<div class=\"content\" style=\"background-color: #fff; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; max-height: 600px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 14px;\">\r\n<div style=\"text-align: center; font-size: 18px; border: 0px dotted #000; padding: 10px; margin-bottom: 20px;\">\r\n<div style=\"text-align: center; font-size: 18px; border: 1px dotted #000; padding: 10px; margin-bottom: 20px;\"><strong><u>USG OF LOWER ABDOMEN</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 14px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>FHR</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Not recordable</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Presentation</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Cephalic</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Fetal Movement</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Absent</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>BPD</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">5.8 cm</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>FL</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">4.1 cm</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Placenta</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Anterior</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Amniotic Fluid</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Average</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spalding Sign</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Present. Skull bone overriding</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gestational Age</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">23 wks. 04 days</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 40%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 60%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">A case of Missed Abortion</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(846, 1252, 41, NULL, 'USG OF WA - Choledocolithiasis - MALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 2, '2024-06-27 01:45:08', '2024-06-27 11:46:25', '<div class=\"content\" style=\"background-color: #fff; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 12px;\">\r\n<div style=\"text-align: center; font-size: 16px; border: 0px dotted #000; padding: 10px; margin-bottom: 20px;\">\r\n<div style=\"text-align: center; font-size: 16px; border: 1px dotted #000; padding: 10px; margin-bottom: 20px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 12px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Normal in size (12.3cm) and homogenous in echotexture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. No echogenic structure or mass is seen in GB lumen.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Dilated (1.6cm). Wall is regular. Contains a bright echogenic structure with strong posterior acoustic shadow.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size, diameter &amp; uniform echotexture. MPD is not dilated.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; uniform echotexture.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Both kidneys are normal in size, shape, and position. Well-defined cortex and medulla. No stone or mass is seen. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall &amp; not thickened. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Prostate</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Normal in size with uniform echotexture. Capsule is intact.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Abdominal Aorta</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">Appears normal. No abdominal mass or lymphadenopathy is seen. No collection of fluid (ascites) is seen in any intra-peritoneal space, including Morrison&rsquo;s Pouch.</td>\r\n</tr>\r\n<tr style=\"height: 15px; background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 25.8786%; text-align: left; height: 15px; padding: 10px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 73.1214%; height: 15px; padding: 10px; border: 1px dotted #000000; text-align: justify;\">A case of Choledocolithiasis.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(847, 1252, 41, NULL, 'USG OF WA - FEMALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 3, '2024-06-27 11:45:41', '2024-06-27 11:54:04', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and homogeneous in echo texture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. No echogenic structure or mass is seen in GB lumen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size, diameter &amp; echo-texture. PD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; echo-texture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both kidneys are normal in size, shape, and position. Well-defined cortex and medulla. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall thickness. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Gravid, Single GS with fetal pole and yolk sac is seen. GS measures 5.60 cm which corresponds to 11 weeks 01 days.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CRL</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">3.74 cm.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gestational Age</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">11 weeks 01 days.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>EDD (according to USG)</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">05/12/2024 (Approx).</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">About 11+ weeks of Intra-uterine pregnancy with single viable fetus with unstable presentation.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(848, 1252, 41, NULL, 'USG OF WA - MALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 4, '2024-06-27 12:01:04', '2024-06-27 12:01:35', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size (13.20cm) and homogenous in echotexture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. No echogenic structure or mass is seen in GB lumen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size &amp; diameter &amp; uniform echotexture. MPD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; uniform echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both the kidneys are normal in size, shape and position. Well defined cortex and medulla. No stone or mass is seen. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall &amp; not thickened. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Prostate</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size with uniform echotexture. Capsule is intact.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal study.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(849, 1252, 41, NULL, 'USG OF WA Appendicitis - MALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 5, '2024-06-27 12:05:01', '2024-06-27 12:05:01', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and homogenous in echotexture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. No echogenic structure or mass is seen in GB lumen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size, diameter &amp; uniform echotexture. MPD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; uniform echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both the kidneys are normal in size, shape and position. Well defined cortex and medulla. No stone or mass is seen. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Visible (Blind ended a peristaltic tube arising from caecum). Mild pericecal collection is seen. Severe tenderness over RIF on probe pressure.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall thickness. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Prostate</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size with uniform echotexture. Capsule is intact.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Abdominal Aorta</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal. No abdominal mass or lymphadenopathy is seen. No collection of fluid (ascites) is seen in any intra-peritoneal space, including Morrison&rsquo;s Pouch.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Suspected of Acute Appendicitis. Pls. clinically correlate.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(850, 1252, 41, NULL, 'USG WA Acute Appendicitis - FEMALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 6, '2024-06-27 12:08:05', '2024-06-27 12:08:20', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size (11.99cm) and normal in parenchymal echotexture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. No echogenic structure or mass is seen in GB lumen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size, diameter &amp; echotexture. PD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; uniform echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both the kidneys are normal in size, shape and position. Well defined cortex and medulla. No stone or mass is seen. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Slightly visible and probe tenderness in M&rsquo;cberneys point is positive.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall thickness. No calculus or lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and shape, anteverted in position, homogenous in appearance and endometrium thickness within normal limit.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Suggestive of 1. Acute appendicitis? (pls correlate with clinical findings) <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.PID</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(851, 1252, 41, NULL, 'USG WA Cholelithiasis - FEMALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 7, '2024-06-27 12:11:38', '2024-06-27 12:12:45', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 600px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size (12.2 cm) and homogenous in echo texture. No focal or diffuse lesion is seen. Intrahepatic biliary tree not dilated. Portal Vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Distended with bile contents &amp; normal wall thickness. An echogenic structure is seen in GB lumen of about 1.07 cm in size casting post. Acoustic shadow.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal in size, diameter &amp; echotexture. PD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both the kidneys are normal in size, shape and position. Well defined cortex and medulla. No stone or mass is seen. PC systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well filled with regular wall thickness. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size, shape &amp; anteverted in position. Normal echo texture of myometrium. Endometrial slit is within normal diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Adnexa</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both ovaries are normal in size, shape &amp; volume. No cyst or mass is seen. No collection in POD.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Abdominal Aorta</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal. No abdominal mass or lymphadenopathy is seen. No collection of fluid (ascites) is seen in any intra-peritoneal space including pouch of Douglas.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Cholelithiasis.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>');
INSERT INTO `test_values` (`id`, `test_type_id`, `test_id`, `value_heading_id`, `name`, `left_result`, `right_result`, `ref_range`, `value`, `type`, `width`, `table_header`, `rank`, `created_at`, `updated_at`, `description`) VALUES
(852, 1252, 41, NULL, 'WA  CYSTITIS', NULL, NULL, NULL, NULL, 5, NULL, NULL, 8, '2024-06-27 12:16:24', '2024-06-27 12:16:24', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size with homogeneous echo texture. No focal or diffuse lesion is seen. Intrahepatic vessels are not well visualized.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>GB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is well visualized with normal wall thickness. No calculus or mass is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size &amp; shape. No focal lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size with uniform echo texture. MPD is not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both kidneys are normal in size, shape and position. Cortex medulla ratios are normal. No calculus or mass is seen. Both Pelvicaliceal systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is well filled with urine. Wall is a thick and irregular margin no focal lesion or calculus is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size with anteverted in position. Normal echo texture of myometrium. Endometrial slit is normal. Cavities are empty.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Adnexa</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both adnexal regions appear normal. No cyst or mass is seen. Abdominal aorta appears normal. No abdominal mass or lymphadenopathy is seen. No collection of fluid (ascites) is seen in any intra-peritoneal space including pouch of Douglas.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">SUSPECTED OF ACUTE CYSTITIS.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(853, 1252, 41, NULL, 'WA - GB  - Sludge - MALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 9, '2024-06-27 12:19:30', '2024-06-27 12:19:30', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and shows normal parenchymal echogenicity with normal echotexture. No focal or diffuse lesion is seen. IHD are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well distended. Wall is thickened &amp; echogenic. Mild collection of low-level, non-shadowing, dependent echoes within the lumen of gall bladder.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Common Bile Duct</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Visible part is normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both are normal in size, outline and normal central sinus echo complex and well-defined cortico-medullary differentiation. No calculus is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Urinary Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well distended, no intravesicular lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size with anteverted in position. Myometrium is homogeneous. Endometrial slit within normal limit. Both ovaries appear normal. No focal lesion is seen. No collection of fluid is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Acute Cholecystitis with GB SLUDGE.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(854, 1252, 41, NULL, 'WA Cholelithiasis - MALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 10, '2024-06-27 12:26:09', '2024-06-27 12:26:09', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size. Echogenically homogenous. No focal or diffuse lesion is seen. Intrahepatic biliary tree are not dilated. No ascites is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>GB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Enlarged in size &amp; shape and well distended. Wall is increased in size. Cavity contains a single echogenic structure measuring (0.8x0.83) cm in the lumen of GB casting posterior acoustic shadow.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated. Wall is regular.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size &amp; shape. No focal lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size and homogeneously echogenic.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both kidneys are normal in size, shape and position. Cortex: medulla ratio is normal. No calculus or mass is seen. Both Pelvicaliceal systems are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Appendix</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not visible.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Ureters</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>UB</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is well filled with urine. No intravesicular lesion seen in the lumen of the urinary bladder.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Prostate</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size, shape and normal in echotexture. Capsule is intact.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Calculus Cholecystitis.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(855, 1252, 41, NULL, 'WA hepatic sol - FEMALE', NULL, NULL, NULL, NULL, 5, NULL, NULL, 11, '2024-06-27 12:29:15', '2024-06-27 12:29:35', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Enlarged in size and shows a well-defined solid mixed echogenic area with calcification measuring about 7.3 x 7.8 cm in Left lobe. IHD are not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Are contracted &amp; wall is thickened &gt; 1cm. No calculus is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Common Bile Duct</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Visible part is normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both are normal in size, outline and normal central sinus echo complex and well defined cortico-medullary differentiation. No calculus is seen. PC system not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Urinary Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well distended. No intravesicular lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Uterus</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size &amp; shape with anteverted in position. Normal echo texture of myometrium. Endometrium is normal. Both ovaries appear to be normal.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Moderate Amount of Ascitic fluid is seen in peritoneal cavity.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Hepatic SOL, Ascitis, Acute Cholecystitis.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(856, 1252, 41, NULL, 'WA Male + GB POLYP', NULL, NULL, NULL, NULL, 5, NULL, NULL, 12, '2024-06-27 12:32:53', '2024-06-27 12:33:08', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 13px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 15px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 13px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Liver</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size (14.04 cm) and inhomogenous in echotexture. No focal or diffuse lesion is seen. Intrahepatic biliary tree are not dilated. Portal vein measures normal in diameter.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Gall Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well distended. No calculus is seen, wall thickness normal, no posterior acoustic shadow is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>CBD</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Not dilated.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Spleen</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Pancreas</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Visible part is normal in size and shows normal parenchymal echotexture.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Kidneys</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Both are normal in size, outline and normal central sinus echo complex and well defined cortico-medullary differentiation. No calculus is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Urinary Bladder</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Well distended, no intravesicular lesion is seen.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Prostate</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Normal in size with intact capsule.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">FATTY CHANGE IN LIVER (G-1)</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(857, 1252, 290, NULL, 'USG Of testis & Scrotum', NULL, NULL, NULL, NULL, 5, NULL, NULL, 1, '2024-06-27 12:40:40', '2024-06-27 12:40:40', '<div class=\"content\" style=\"background-color: #fff; padding: 10px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); max-width: 800px; height: 500px; margin: auto; font-family: \'Times New Roman\', serif; font-size: 15px;\">\r\n<div style=\"text-align: center; font-size: 17px; border: 0px dotted #000; padding: 5px; margin-bottom: 10px;\">\r\n<div style=\"text-align: center; font-size: 17px; border: 1px dotted #000; padding: 5px; margin-bottom: 10px;\"><strong><u>USG Of Whole Abdomen</u></strong></div>\r\n<table style=\"width: 100%; border-collapse: collapse; font-size: 15px; border: 1px dotted #000;\">\r\n<tbody>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Right Testis</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size with position (3.0x1.8x3.60 cm). Parenchymal echotexture is uniform. Epididymis appears normal. Mild fluid collection is seen in Rt scrotal cavity.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Left Testis</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Is normal in size and position. Single anechoic structure is seen in upper pole of Lt. testis, measuring about 1.2 cm. No focal lesion is seen. Epididymis appears normal. No collection is seen in Lt Hemi scrotal sac.</td>\r\n</tr>\r\n<tr style=\"background-color: #e0f7fa; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Epididymis</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Appears normal.</td>\r\n</tr>\r\n<tr style=\"background-color: #ffffff; color: #000000; border: 1px dotted #000000;\">\r\n<th style=\"width: 30.5103%; text-align: left; padding: 5px; background-color: #b2ebf2; border: 1px dotted #000000;\"><strong>Comment</strong></th>\r\n<td style=\"width: 68.4897%; padding: 5px; border: 1px dotted #000000; text-align: justify;\">Rt. Sided hydrocele (mild) with Lt. testicular single cyst.</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</div>'),
(858, 1248, 60, NULL, 'RBC', NULL, NULL, 'Anisochromasia , Anisocytosis  including seldom microcytes  with mild rouleaux formation.', NULL, 2, NULL, NULL, 2, '2024-11-12 23:17:50', '2024-11-12 23:18:23', NULL),
(859, 1248, 60, NULL, 'WBC', NULL, NULL, 'Mature with normal in count and distribution.', NULL, 2, NULL, NULL, 3, '2024-11-12 23:18:34', '2024-11-12 23:18:34', NULL),
(860, 1248, 60, NULL, 'Platelet', NULL, NULL, 'Adequate. <br> No immature cell or parasite is seen.', NULL, 2, NULL, NULL, 4, '2024-11-12 23:19:28', '2024-11-12 23:19:28', NULL),
(861, 1248, 60, NULL, 'Comment', NULL, NULL, 'Non specific  findings.', NULL, 2, NULL, NULL, 5, '2024-11-12 23:19:58', '2024-11-12 23:19:58', NULL),
(862, 1248, 60, NULL, 'Advice', NULL, NULL, 'clinical co-relation', NULL, 2, NULL, NULL, 6, '2024-11-12 23:21:04', '2024-11-12 23:21:04', NULL),
(863, 1250, 744, NULL, 'CRP(Q)', NULL, 'mg/L', '0-10 mg/L', NULL, 2, NULL, NULL, 1, '2024-11-13 00:06:23', '2024-11-13 00:06:23', NULL),
(864, 1250, 744, NULL, 'hsCRP', NULL, 'mg/L', '0-1.0 mg/L', NULL, 2, NULL, NULL, 2, '2024-11-13 00:06:56', '2024-11-13 00:06:56', NULL),
(865, 1253, 383, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, 2, '2024-11-13 00:17:20', '2024-11-13 00:17:20', '<ul>\r\n<li><strong>Immunoglobulin IgE</strong><br /> It is used to establish the diagnosis of an allergy and to define the allergens responsible for eliciting signs and symptoms. It may be ordered to determine asthma triggers.</li>\r\n</ul>'),
(866, 1246, 2, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2025-03-04 12:49:01', '2025-03-04 12:49:01', NULL),
(867, 1246, 2, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2025-03-24 14:45:01', '2025-03-24 14:45:01', NULL),
(868, 1247, 39, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2025-04-20 01:24:14', '2025-04-20 01:24:14', NULL),
(869, 1253, 540, NULL, 'AMH ( ANTI MULLERIAN HORMONE)', NULL, 'ng/ml', 'High (oftern PCOS) : Over 3.0 ng/ml <br>  Normal :  over 1.0 ng/ml  <br> Low Normal Range : 0.7 - 0.9 ng/ml  <br> Low : 0.3-0.6 ng/ml <br> Very Low : Less than 0.3 ng/ml', NULL, 2, NULL, NULL, 1, '2025-05-09 06:52:06', '2025-05-09 07:00:07', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `treatments`
--

CREATE TABLE `treatments` (
  `id` int UNSIGNED NOT NULL,
  `payment_id` int DEFAULT NULL,
  `patient_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `quantity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `day` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `mgml` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tab_type` varchar(222) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatments`
--

INSERT INTO `treatments` (`id`, `payment_id`, `patient_id`, `product_id`, `quantity`, `schedule_id`, `day`, `type`, `mgml`, `tab_type`, `remarks`, `created_at`, `updated_at`) VALUES
(1, 439, 3111, 24, NULL, '12', '1+0+1', NULL, '500mg', 'tab', NULL, '2023-07-12 07:52:57', '2023-07-12 07:52:57'),
(2, 5, 6264, 90, NULL, '3', '1+0+2', NULL, '500mg', 'tab', NULL, '2024-04-24 14:17:39', '2024-04-24 08:17:39'),
(3, 16, 6706, 90, NULL, '2', '2', NULL, NULL, 'tab', '685+62', '2024-07-02 10:54:11', '2024-07-02 04:54:11'),
(4, 4, 6836, 91, NULL, '10', '2', NULL, '500MG', 'TAB', '1+0+1', '2024-10-15 05:25:08', '2024-10-14 23:25:08'),
(5, 59, 6947, 94, NULL, '10', '1+0+1', NULL, '500mg', 'Tab', NULL, '2025-03-16 18:43:44', '2025-03-16 12:43:44'),
(6, 59, 6947, 95, NULL, '15', '0+0+1', NULL, '200mg', 'Tab', NULL, '2025-03-16 18:43:44', '2025-03-16 12:43:44'),
(7, 59, 6947, 96, NULL, '10', '1+0+1', NULL, '20mg', 'Tab', NULL, '2025-03-16 18:43:44', '2025-03-16 12:43:44'),
(8, 62, 6912, 97, NULL, '4', '0+1+1', NULL, '500MG', 'TAB', 'A', '2025-03-17 17:05:24', '2025-03-17 11:05:24'),
(9, 62, 6912, 98, NULL, NULL, NULL, NULL, NULL, 'INJU', NULL, '2025-03-17 17:05:24', '2025-03-17 11:05:24'),
(10, 85, 6964, 90, NULL, '10', '1+1+1', NULL, '500mg', 'tab', NULL, '2025-04-29 05:58:13', '2025-04-28 23:58:13');

-- --------------------------------------------------------

--
-- Table structure for table `user_logs`
--

CREATE TABLE `user_logs` (
  `id` int NOT NULL,
  `admin_id` int DEFAULT NULL,
  `patient_id` int DEFAULT NULL,
  `test_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `invoice` int DEFAULT NULL,
  `total_amount` double DEFAULT NULL,
  `received_amount` double DEFAULT NULL,
  `total_test` double DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logs`
--

INSERT INTO `user_logs` (`id`, `admin_id`, `patient_id`, `test_id`, `invoice`, `total_amount`, `received_amount`, `total_test`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, 6716, '[\"30\",\"49\",\"710\",\"716\",\"717\"]', 20240706, 1315, 1200, 5, 'total test: 5, total test amount: 1315, total received: 1200, received by: Admin', '2024-07-09 06:56:01', '2024-07-09 06:56:01'),
(2, 1, 6715, '[\"2\",\"709\",\"710\",\"10\",\"716\"]', 20240705, 1125, 500, 5, 'total test: 5, total test amount: 1125, total received: 500, received by: Admin', '2024-07-09 06:57:59', '2024-07-09 06:57:59'),
(3, 1, 6714, '[\"41\",\"10\",\"710\",\"716\"]', 20240705, 2230, 1200, 4, 'total test: 4, total test amount: 2230, total received: 1200, received by: Admin', '2024-07-09 06:58:43', '2024-07-09 06:58:43'),
(4, 1, 6697, '[\"2\",\"709\",\"710\"]', 20240702, 130, 130, 3, 'total test: 3, total test amount: 130, total received: 130, received by: Admin', '2024-07-09 07:02:28', '2024-07-09 07:02:28'),
(5, 1, 6696, '[\"2\",\"709\",\"710\"]', 20240709, 160, 100, 3, 'total test: 3, total test amount: 160, total received: 100, received by: Admin', '2024-07-09 07:04:15', '2024-07-09 07:04:15'),
(6, 1, 6696, '[\"2\",\"709\",\"710\"]', 20240709, 100, 0, 3, 'total test: 3, total test amount: 100, total received: 0, received by: Admin', '2024-07-09 07:05:58', '2024-07-09 07:05:58'),
(7, 1, 6719, '[\"2\",\"709\",\"710\"]', 20240710, 150, 150, 3, 'total test: 3, total test amount: 150, total received: 150, received by: Admin', '2024-07-10 00:51:25', '2024-07-10 00:51:25'),
(8, 1, 6720, '[\"2\",\"49\",\"71\",\"41\",\"709\",\"710\",\"717\",\"716\"]', 20240715, 2930, 1500, 8, 'total test: 8, total test amount: 2930, total received: 1500, received by: Admin', '2024-07-15 03:23:30', '2024-07-15 03:23:30'),
(9, 1, 6721, '[\"2\",\"3\",\"35\",\"23\",\"41\",\"322\",\"709\",\"710\",\"713\",\"716\"]', 20240715, 3760, 1500, 10, 'total test: 10, total test amount: 3760, total received: 1500, received by: Admin', '2024-07-15 04:10:45', '2024-07-15 04:10:45'),
(10, 1, 6722, '[\"48\",\"14\",\"62\",\"161\",\"710\",\"717\",\"716\"]', 20240716, 1445, 700, 7, 'total test: 7, total test amount: 1445, total received: 700, received by: Admin', '2024-07-15 22:22:52', '2024-07-15 22:22:52'),
(11, 1, 6722, '[\"14\",\"710\",\"716\",\"48\",\"717\",\"62\",\"161\",\"710\",\"716\",\"717\"]', 20240716, 1545, 845, 10, 'refund test: 10, total test amount: 1545, total refund: 845, refund by: Admin', '2024-07-16 23:46:58', '2024-07-16 23:46:58'),
(12, 1, 6724, '[\"43\"]', 20240717, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Admin', '2024-07-17 01:39:50', '2024-07-17 01:39:50'),
(13, 1, 6696, '[\"2\",\"709\",\"710\"]', 20240717, 180, 100, 3, 'total test: 3, total test amount: 180, total received: 100, received by: Admin', '2024-07-17 02:04:26', '2024-07-17 02:04:26'),
(14, 1, 6725, '[\"13\",\"48\",\"62\",\"710\",\"716\",\"717\"]', 20240725, 1000, NULL, 6, 'total test: 6, total test amount: 1000, total received: , received by: Admin', '2024-07-25 06:22:42', '2024-07-25 06:22:42'),
(15, 1, 6725, '[\"58\",\"124\",\"27\",\"104\",\"710\",\"716\",\"713\"]', 20240726, 1295, NULL, 7, 'total test: 7, total test amount: 1295, total received: , received by: Admin', '2024-07-25 12:33:20', '2024-07-25 12:33:20'),
(16, 1, 6726, '[\"3\",\"709\",\"710\"]', 20240726, 180, 0, 3, 'total test: 3, total test amount: 180, total received: 0, received by: Admin', '2024-07-25 12:40:40', '2024-07-25 12:40:40'),
(17, 1, 6728, '[\"116\"]', 20240726, 200, NULL, 1, 'total test: 1, total test amount: 200, total received: , received by: Admin', '2024-07-26 02:36:26', '2024-07-26 02:36:26'),
(18, 1, 6729, '[\"64\",\"122\",\"39\"]', 20240727, 1525, NULL, 3, 'total test: 3, total test amount: 1525, total received: , received by: Admin', '2024-07-26 12:11:15', '2024-07-26 12:11:15'),
(19, 1, 6730, '[\"9\",\"2\",\"39\",\"23\",\"19\",\"14\",\"710\",\"716\",\"709\"]', 20240727, 3445, 445, 9, 'total test: 9, total test amount: 3445, total received: 445, received by: Admin', '2024-07-27 11:41:53', '2024-07-27 11:41:53'),
(20, 1, 6731, '[\"46\"]', 20240728, 1200, NULL, 1, 'total test: 1, total test amount: 1200, total received: , received by: Admin', '2024-07-27 12:11:49', '2024-07-27 12:11:49'),
(21, 1, 6732, '[\"10\",\"14\",\"39\",\"38\",\"62\",\"78\",\"77\",\"73\",\"105\",\"710\",\"716\"]', 20240728, 6575, 1575, 11, 'total test: 11, total test amount: 6575, total received: 1575, received by: Admin', '2024-07-27 12:41:37', '2024-07-27 12:41:37'),
(22, 1, 6733, '[\"10\",\"710\",\"716\"]', 20240728, 1030, NULL, 3, 'total test: 3, total test amount: 1030, total received: , received by: Admin', '2024-07-28 02:02:53', '2024-07-28 02:02:53'),
(23, 1, 6734, '[\"407\",\"48\",\"42\",\"10\",\"9\",\"710\",\"717\",\"716\"]', 20240728, 465, 465, 8, 'total test: 8, total test amount: 465, total received: 465, received by: Admin', '2024-07-28 02:06:31', '2024-07-28 02:06:31'),
(24, 1, 6733, '[\"407\"]', 20240728, 100, 100, 1, 'total test: 1, total test amount: 100, total received: 100, received by: Admin', '2024-07-28 02:10:41', '2024-07-28 02:10:41'),
(25, 1, 6733, '[\"2\",\"709\",\"710\"]', 20240728, 180, 100, 3, 'total test: 3, total test amount: 180, total received: 100, received by: Admin', '2024-07-28 02:11:40', '2024-07-28 02:11:40'),
(26, 1, 6730, '[\"5\",\"10\",\"3\",\"10\",\"5\",\"709\",\"710\",\"716\"]', 20240728, 1595, NULL, 6, 'total test: 6, total test amount: 1595, total received: , received by: Admin', '2024-07-28 06:08:17', '2024-07-28 06:08:17'),
(27, 1, 6705, '[\"10\",\"710\",\"716\"]', 20240728, 1030, NULL, 3, 'total test: 3, total test amount: 1030, total received: , received by: Admin', '2024-07-28 06:38:58', '2024-07-28 06:38:58'),
(28, 1, 6737, '[\"10\",\"30\",\"49\",\"62\",\"710\",\"716\",\"717\"]', 20240728, 2765, NULL, 7, 'total test: 7, total test amount: 2765, total received: , received by: Admin', '2024-07-28 10:08:43', '2024-07-28 10:08:43'),
(29, 1, 6738, '[\"9\",\"5\",\"21\",\"19\",\"22\",\"710\",\"716\",\"709\"]', 20240728, 2745, NULL, 8, 'total test: 8, total test amount: 2745, total received: , received by: Admin', '2024-07-28 10:11:05', '2024-07-28 10:11:05'),
(30, 1, 6739, '[\"2\",\"48\",\"62\",\"13\",\"709\",\"710\",\"717\",\"716\"]', 20240729, 1535, NULL, 8, 'total test: 8, total test amount: 1535, total received: , received by: Admin', '2024-07-28 23:52:55', '2024-07-28 23:52:55'),
(31, 1, 6740, '[\"45\",\"43\",\"39\"]', 20240729, 2450, NULL, 3, 'total test: 3, total test amount: 2450, total received: , received by: Admin', '2024-07-29 05:50:18', '2024-07-29 05:50:18'),
(32, 1, 6721, '[\"9\",\"710\",\"716\"]', 20240729, 750, 200, 3, 'total test: 3, total test amount: 750, total received: 200, received by: Admin', '2024-07-29 06:24:46', '2024-07-29 06:24:46'),
(33, 1, 6741, '[\"44\"]', 20240731, 1000, 500, 1, 'total test: 1, total test amount: 1000, total received: 500, received by: Admin', '2024-07-31 01:01:52', '2024-07-31 01:01:52'),
(34, 1, 6742, '[\"43\"]', 20240731, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Admin', '2024-07-31 01:05:25', '2024-07-31 01:05:25'),
(35, 1, 6715, '[\"2\",\"3\",\"709\",\"710\"]', 20240731, 330, NULL, 4, 'total test: 4, total test amount: 330, total received: , received by: Admin', '2024-07-31 02:16:08', '2024-07-31 02:16:08'),
(36, 1, 6743, '[\"2\",\"709\",\"710\"]', 20240809, 150, 150, 3, 'total test: 3, total test amount: 150, total received: 150, received by: Dialab Pro', '2024-08-09 10:06:01', '2024-08-09 10:06:01'),
(37, 1, 6744, '[\"3\",\"10\",\"709\",\"710\",\"716\"]', 20240809, 850, 500, 5, 'total test: 5, total test amount: 850, total received: 500, received by: Dialab Pro', '2024-08-09 10:06:59', '2024-08-09 10:06:59'),
(38, 1, 6745, '[\"407\"]', 20240810, 100, 50, 1, 'total test: 1, total test amount: 100, total received: 50, received by: Dialab Pro', '2024-08-11 04:10:15', '2024-08-11 04:10:15'),
(39, 1, 6746, '[\"407\",\"404\",\"41\",\"710\",\"716\"]', 20240811, 1305, 500, 5, 'total test: 5, total test amount: 1305, total received: 500, received by: Dialab Pro', '2024-08-11 08:25:16', '2024-08-11 08:25:16'),
(40, 1, 6746, '[\"41\",\"404\",\"407\",\"710\",\"716\"]', 20240811, 1305, 500, 5, 'total test: 5, total test amount: 1305, total received: 500, received by: Dialab Pro', '2024-08-13 04:47:31', '2024-08-13 04:47:31'),
(41, 1, 6746, '[\"41\",\"404\",\"407\",\"710\",\"716\"]', 20240811, 1305, 500, 5, 'total test: 5, total test amount: 1305, total received: 500, received by: Dialab Pro', '2024-08-13 04:56:49', '2024-08-13 04:56:49'),
(42, 1, 6746, '[\"41\",\"404\",\"407\",\"710\",\"716\"]', 20240811, 1305, 500, 5, 'total test: 5, total test amount: 1305, total received: 500, received by: Dialab Pro', '2024-08-13 05:43:05', '2024-08-13 05:43:05'),
(43, 1, 6743, '[\"2\",\"3\",\"5\",\"41\",\"709\",\"710\"]', 20240813, 1835, NULL, 6, 'total test: 6, total test amount: 1835, total received: , received by: Dialab Pro', '2024-08-13 06:33:14', '2024-08-13 06:33:14'),
(44, 1, 6743, '[\"2\",\"3\",\"5\",\"41\",\"709\",\"710\"]', 20240813, 1835, 0, 6, 'total test: 6, total test amount: 1835, total received: 0, received by: Dialab Pro', '2024-08-14 01:01:05', '2024-08-14 01:01:05'),
(45, 1, 6747, '[\"2\",\"9\",\"709\",\"710\",\"716\"]', 20240814, 695, 400, 5, 'total test: 5, total test amount: 695, total received: 400, received by: Dialab Pro', '2024-08-14 01:10:38', '2024-08-14 01:10:38'),
(46, 1, 6747, '[\"2\",\"9\",\"709\",\"710\",\"716\"]', 20240814, 694.9996, 400, 5, 'total test: 5, total test amount: 694.9996, total received: 400, received by: Dialab Pro', '2024-08-14 01:25:30', '2024-08-14 01:25:30'),
(47, 1, 6747, '[\"2\",\"709\",\"710\",\"9\",\"716\",\"709\",\"710\",\"716\"]', 20240814, 99.99959999999999, 694.9996, 8, 'refund test: 8, total test amount: 99.9996, total refund: 694.9996, refund by: Dialab Pro', '2024-08-14 08:06:26', '2024-08-14 08:06:26'),
(48, 1, 6748, '[\"2\",\"709\",\"710\"]', 20240815, 150, 100, 3, 'total test: 3, total test amount: 150, total received: 100, received by: Dialab Pro', '2024-08-15 07:54:50', '2024-08-15 07:54:50'),
(49, 1, 6749, '[\"2\",\"71\",\"10\",\"709\",\"710\",\"716\"]', 20240816, 1895, 500, 6, 'total test: 6, total test amount: 1895, total received: 500, received by: Dialab Pro', '2024-08-16 02:57:46', '2024-08-16 02:57:46'),
(50, 1, 6750, '[\"71\",\"2\",\"710\",\"716\",\"709\"]', 20240816, 1195, 500, 5, 'total test: 5, total test amount: 1195, total received: 500, received by: Dialab Pro', '2024-08-16 03:31:45', '2024-08-16 03:31:45'),
(51, 1, 6749, '[\"41\"]', 20240816, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Dialab Pro', '2024-08-16 03:35:27', '2024-08-16 03:35:27'),
(52, 1, 6751, '[\"2\",\"709\",\"710\"]', 20240816, 180, 150, 3, 'total test: 3, total test amount: 180, total received: 150, received by: Dialab Pro', '2024-08-16 05:05:33', '2024-08-16 05:05:33'),
(53, 1, 6751, '[\"2\",\"709\",\"710\"]', 20240816, 180, 150, 3, 'total test: 3, total test amount: 180, total received: 150, received by: Dialab Pro', '2024-08-16 07:37:31', '2024-08-16 07:37:31'),
(54, 1, 6753, '[\"2\",\"709\",\"710\"]', 20240818, 130, 100, 3, 'total test: 3, total test amount: 130, total received: 100, received by: Dialab Pro', '2024-08-18 08:02:24', '2024-08-18 08:02:24'),
(55, 1, 6754, '[\"407\",\"71\",\"48\",\"710\",\"716\",\"717\"]', 20240819, 1440, 1000, 6, 'total test: 6, total test amount: 1440, total received: 1000, received by: Dialab Pro', '2024-08-19 04:25:07', '2024-08-19 04:25:07'),
(56, 1, 6753, '[\"2\",\"709\",\"710\"]', 20240819, 180, NULL, 3, 'total test: 3, total test amount: 180, total received: , received by: Dialab Pro', '2024-08-19 06:19:57', '2024-08-19 06:19:57'),
(57, 1, 6755, '[\"2\",\"5\",\"709\",\"710\"]', 20240820, 443, 300, 4, 'total test: 4, total test amount: 443, total received: 300, received by: Dialab Pro', '2024-08-19 23:45:02', '2024-08-19 23:45:02'),
(58, 1, 6756, '[\"2\",\"5\",\"709\",\"710\"]', 20240820, 500, 200, 4, 'total test: 4, total test amount: 500, total received: 200, received by: Dialab Pro', '2024-08-20 00:46:41', '2024-08-20 00:46:41'),
(59, 1, 6757, '[\"71\",\"710\",\"716\"]', 20240820, 1230, 1230, 3, 'total test: 3, total test amount: 1230, total received: 1230, received by: Dialab Pro', '2024-08-20 01:08:05', '2024-08-20 01:08:05'),
(60, 1, 6756, '[\"2\",\"5\",\"709\",\"710\",\"709\",\"710\"]', 20240820, 120, 500, 6, 'refund test: 6, total test amount: 120, total refund: 500, refund by: Dialab Pro', '2024-08-20 01:28:21', '2024-08-20 01:28:21'),
(61, 1, 6758, '[\"2\",\"709\",\"710\"]', 20240820, 170, 100, 3, 'total test: 3, total test amount: 170, total received: 100, received by: Dialab Pro', '2024-08-20 01:32:44', '2024-08-20 01:32:44'),
(62, 1, 6758, '[\"2\",\"709\",\"710\",\"709\",\"710\"]', 20240820, 90, 170, 5, 'refund test: 5, total test amount: 90, total refund: 170, refund by: Dialab Pro', '2024-08-20 01:33:23', '2024-08-20 01:33:23'),
(63, 1, 6759, '[\"2\",\"709\",\"710\"]', 20240820, 170, 100, 3, 'total test: 3, total test amount: 170, total received: 100, received by: Dialab Pro', '2024-08-20 01:36:36', '2024-08-20 01:36:36'),
(64, 1, 6759, '[\"2\",\"709\",\"710\",\"709\",\"710\"]', 20240820, 90, 170, 5, 'refund test: 5, total test amount: 90, total refund: 170, refund by: Dialab Pro', '2024-08-20 01:37:16', '2024-08-20 01:37:16'),
(65, 1, 6761, '[\"2\",\"71\",\"709\",\"710\",\"716\"]', 20240821, 1125, 500, 5, 'total test: 5, total test amount: 1125, total received: 500, received by: Dialab Pro', '2024-08-20 23:01:03', '2024-08-20 23:01:03'),
(66, 1, 6762, '[\"10\",\"710\",\"716\"]', 20240821, 630, 500, 3, 'total test: 3, total test amount: 630, total received: 500, received by: Dialab Pro', '2024-08-20 23:05:07', '2024-08-20 23:05:07'),
(67, 1, 6760, '[\"49\",\"710\",\"717\"]', 20240821, 500, 500, 3, 'total test: 3, total test amount: 500, total received: 500, received by: Dialab Pro', '2024-08-20 23:08:32', '2024-08-20 23:08:32'),
(68, 1, 6762, '[\"49\",\"710\",\"717\"]', 20240821, 650, 650, 3, 'total test: 3, total test amount: 650, total received: 650, received by: Dialab Pro', '2024-08-20 23:13:16', '2024-08-20 23:13:16'),
(69, 1, 6760, '[\"41\"]', 20240821, 900, 900, 1, 'total test: 1, total test amount: 900, total received: 900, received by: Dialab Pro', '2024-08-20 23:21:47', '2024-08-20 23:21:47'),
(70, 1, 6763, '[\"2\",\"10\",\"48\",\"709\",\"710\",\"716\",\"717\"]', 20240821, 1400, 1000, 7, 'total test: 7, total test amount: 1400, total received: 1000, received by: Dialab Pro', '2024-08-21 06:49:28', '2024-08-21 06:49:28'),
(71, 1, 6764, '[\"48\",\"407\",\"13\",\"62\",\"395\",\"710\",\"717\",\"716\"]', 20240821, 2000, 2000, 8, 'total test: 8, total test amount: 2000, total received: 2000, received by: Dialab Pro', '2024-08-21 06:55:41', '2024-08-21 06:55:41'),
(72, 1, 6765, '[\"48\",\"407\",\"71\",\"540\",\"710\",\"717\",\"716\"]', 20240821, 4815, 4000, 7, 'total test: 7, total test amount: 4815, total received: 4000, received by: Dialab Pro', '2024-08-21 07:08:51', '2024-08-21 07:08:51'),
(73, 1, 6765, '[\"48\",\"710\",\"717\",\"71\",\"407\",\"540\",\"710\",\"716\",\"717\"]', 20240821, 3450.713, -99.28699999999992, 9, 'refund test: 9, total test amount: 3450.713, total refund: -99.287, refund by: Dialab Pro', '2024-08-21 07:35:57', '2024-08-21 07:35:57'),
(74, 1, 6766, '[\"616\",\"540\",\"71\",\"73\",\"62\",\"710\",\"716\"]', 20240821, 6530, 6000, 7, 'total test: 7, total test amount: 6530, total received: 6000, received by: Dialab Pro', '2024-08-21 07:44:10', '2024-08-21 07:44:10'),
(75, 1, 6760, '[\"62\"]', 20240822, 200, 200, 1, 'total test: 1, total test amount: 200, total received: 200, received by: Dialab Pro', '2024-08-21 13:06:41', '2024-08-21 13:06:41'),
(76, 1, 6768, '[\"2\",\"709\",\"710\"]', 20240822, 135, 135, 3, 'total test: 3, total test amount: 135, total received: 135, received by: Dialab Pro', '2024-08-22 02:09:01', '2024-08-22 02:09:01'),
(77, 1, 6769, '[\"407\",\"404\",\"124\",\"710\",\"716\"]', 20240822, 1205, 0, 5, 'total test: 5, total test amount: 1205, total received: 0, received by: Dialab Pro', '2024-08-22 09:03:58', '2024-08-22 09:03:58'),
(78, 1, 6770, '[\"2\",\"709\",\"710\"]', 20240823, 100, 50, 3, 'total test: 3, total test amount: 100, total received: 50, received by: Dialab Pro', '2024-08-22 12:06:48', '2024-08-22 12:06:48'),
(79, 1, 6771, '[\"2\",\"709\",\"710\"]', 20240823, 130, 100, 3, 'total test: 3, total test amount: 130, total received: 100, received by: Dialab Pro', '2024-08-22 12:38:12', '2024-08-22 12:38:12'),
(80, 1, 6772, '[\"2\",\"709\",\"710\"]', 20240823, 150, 70, 3, 'total test: 3, total test amount: 150, total received: 70, received by: Dialab Pro', '2024-08-22 12:41:47', '2024-08-22 12:41:47'),
(81, 1, 6773, '[\"71\",\"2\",\"48\",\"710\",\"716\",\"709\",\"717\"]', 20240823, 1480, 500, 7, 'total test: 7, total test amount: 1480, total received: 500, received by: Dialab Pro', '2024-08-22 22:43:19', '2024-08-22 22:43:19'),
(82, 1, 6774, '[\"48\",\"407\",\"13\",\"19\",\"20\",\"710\",\"717\",\"716\"]', 20240824, 0, NULL, 8, 'total test: 8, total test amount: 0, total received: , received by: Dialab Pro', '2024-08-24 09:28:10', '2024-08-24 09:28:10'),
(83, 1, 6778, '[\"367\"]', 20240825, 300, NULL, 1, 'total test: 1, total test amount: 300, total received: , received by: Dialab Pro', '2024-08-25 00:15:26', '2024-08-25 00:15:26'),
(84, 1, 6779, '[\"2\",\"3\",\"71\",\"49\",\"709\",\"710\",\"716\",\"717\"]', 20240827, 1655, 1000, 8, 'total test: 8, total test amount: 1655, total received: 1000, received by: Dialab Pro', '2024-08-27 00:49:51', '2024-08-27 00:49:51'),
(85, 1, 6782, '[\"2\",\"709\",\"710\"]', 20240827, 180, 50, 3, 'total test: 3, total test amount: 180, total received: 50, received by: Dialab Pro', '2024-08-27 01:03:07', '2024-08-27 01:03:07'),
(86, 1, 6778, '[\"2\",\"709\",\"710\"]', 20240827, 180, 20, 3, 'total test: 3, total test amount: 180, total received: 20, received by: Dialab Pro', '2024-08-27 05:22:51', '2024-08-27 05:22:51'),
(87, 1, 6772, '[\"2\",\"709\",\"710\"]', 20240827, 170, 100, 3, 'total test: 3, total test amount: 170, total received: 100, received by: Dialab Pro', '2024-08-27 05:34:55', '2024-08-27 05:34:55'),
(88, 1, 6771, '[\"2\",\"709\",\"710\"]', 20240827, 170, NULL, 3, 'total test: 3, total test amount: 170, total received: , received by: Dialab Pro', '2024-08-27 05:39:21', '2024-08-27 05:39:21'),
(89, 1, 6772, '[\"2\",\"709\",\"710\"]', 20240827, 180, 100, 3, 'total test: 3, total test amount: 180, total received: 100, received by: Dialab Pro', '2024-08-27 05:40:11', '2024-08-27 05:40:11'),
(90, 1, 6783, '[\"3\",\"9\",\"709\",\"710\",\"716\"]', 20240829, 905, 200, 5, 'total test: 5, total test amount: 905, total received: 200, received by: Dialab Pro', '2024-08-29 02:30:34', '2024-08-29 02:30:34'),
(91, 1, 6784, '[\"2\",\"709\",\"710\"]', 20240829, 150, 100, 3, 'total test: 3, total test amount: 150, total received: 100, received by: Dialab Pro', '2024-08-29 03:12:31', '2024-08-29 03:12:31'),
(92, 1, 6784, '[\"5\",\"9\",\"3\",\"9\",\"709\",\"710\",\"716\"]', 20240829, 1395, NULL, 6, 'total test: 6, total test amount: 1395, total received: , received by: Dialab Pro', '2024-08-29 11:21:45', '2024-08-29 11:21:45'),
(93, 1, 6786, '[\"2\",\"9\",\"14\",\"27\",\"709\",\"710\",\"716\"]', 20240830, 1495, 500, 7, 'total test: 7, total test amount: 1495, total received: 500, received by: Dialab Pro', '2024-08-30 03:03:27', '2024-08-30 03:03:27'),
(94, 1, 6787, '[\"2\",\"709\",\"710\"]', 20240830, 180, NULL, 3, 'total test: 3, total test amount: 180, total received: , received by: Dialab Pro', '2024-08-30 06:44:54', '2024-08-30 06:44:54'),
(95, 1, 6788, '[\"95\",\"710\",\"716\"]', 20240831, 530, NULL, 3, 'total test: 3, total test amount: 530, total received: , received by: Dialab Pro', '2024-08-31 02:31:59', '2024-08-31 02:31:59'),
(96, 1, 6784, '[\"71\",\"710\",\"716\"]', 20240901, 1030, 500, 3, 'total test: 3, total test amount: 1030, total received: 500, received by: Dialab Pro', '2024-09-01 00:57:41', '2024-09-01 00:57:41'),
(97, 1, 6789, '[\"2\",\"709\",\"710\"]', 20240901, 172, 100, 3, 'total test: 3, total test amount: 172, total received: 100, received by: Dialab Pro', '2024-09-01 02:11:26', '2024-09-01 02:11:26'),
(98, 1, 6790, '[\"407\",\"48\",\"710\",\"717\"]', 20240901, 550, 550, 4, 'total test: 4, total test amount: 550, total received: 550, received by: Dialab Pro', '2024-09-01 03:27:45', '2024-09-01 03:27:45'),
(99, 1, 6792, '[\"2\",\"3\",\"5\",\"709\",\"710\"]', 20240901, 730, NULL, 5, 'total test: 5, total test amount: 730, total received: , received by: Dialab Pro', '2024-09-01 06:28:19', '2024-09-01 06:28:19'),
(100, 1, 6792, '[\"2\",\"3\",\"5\",\"709\",\"710\"]', 20240901, 730, 0, 5, 'total test: 5, total test amount: 730, total received: 0, received by: Dialab Pro', '2024-09-01 06:51:18', '2024-09-01 06:51:18'),
(101, 1, 6792, '[\"2\",\"3\",\"5\",\"709\",\"710\"]', 20240901, 730, 0, 5, 'total test: 5, total test amount: 730, total received: 0, received by: Dialab Pro', '2024-09-01 12:27:54', '2024-09-01 12:27:54'),
(102, 1, 6793, '[\"2\",\"709\",\"710\"]', 20240902, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2024-09-01 23:13:44', '2024-09-01 23:13:44'),
(103, 1, 6793, '[\"2\",\"709\",\"710\"]', 20240902, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2024-09-01 23:23:48', '2024-09-01 23:23:48'),
(104, 1, 6794, '[\"48\",\"404\",\"407\",\"158\",\"143\",\"710\",\"717\",\"716\"]', 20240902, 1650, NULL, 8, 'total test: 8, total test amount: 1650, total received: , received by: Dialab Pro', '2024-09-02 01:50:14', '2024-09-02 01:50:14'),
(105, 1, 6794, '[\"48\",\"143\",\"158\",\"404\",\"407\",\"710\",\"716\",\"717\"]', 20240902, 1200, 0, 8, 'total test: 8, total test amount: 1200, total received: 0, received by: Dialab Pro', '2024-09-02 09:03:02', '2024-09-02 09:03:02'),
(106, 1, 6794, '[\"48\",\"143\",\"158\",\"404\",\"407\",\"710\",\"716\",\"717\"]', 20240902, 1200, 0, 8, 'total test: 8, total test amount: 1200, total received: 0, received by: Dialab Pro', '2024-09-02 09:07:52', '2024-09-02 09:07:52'),
(107, 1, 6795, '[\"2\",\"5\",\"709\",\"710\"]', 20240902, 580, 500, 4, 'total test: 4, total test amount: 580, total received: 500, received by: Dialab Pro', '2024-09-02 11:52:52', '2024-09-02 11:52:52'),
(108, 1, 6796, '[\"2\",\"5\",\"709\",\"710\"]', 20240903, 415, 200, 4, 'total test: 4, total test amount: 415, total received: 200, received by: Dialab Pro', '2024-09-03 06:18:19', '2024-09-03 06:18:19'),
(109, 1, 6798, '[\"41\"]', 20240903, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Dialab Pro', '2024-09-03 06:28:02', '2024-09-03 06:28:02'),
(110, 1, 6799, '[\"407\",\"13\",\"16\",\"19\",\"710\",\"716\"]', 20240903, -0.00000000000022737367544323206, 0, 6, 'total test: 6, total test amount: -2.2737367544323E-13, total received: 0, received by: Dialab Pro', '2024-09-03 08:20:54', '2024-09-03 08:20:54'),
(111, 1, 6798, '[\"3\",\"709\",\"710\"]', 20240905, 150, 100, 3, 'total test: 3, total test amount: 150, total received: 100, received by: Dialab Pro', '2024-09-04 14:56:17', '2024-09-04 14:56:17'),
(112, 1, 6798, '[\"2\",\"709\",\"710\"]', 20240905, 160, 100, 3, 'total test: 3, total test amount: 160, total received: 100, received by: Dialab Pro', '2024-09-05 01:25:23', '2024-09-05 01:25:23'),
(113, 1, 6798, '[\"9\",\"39\",\"44\",\"710\",\"716\"]', 20240905, 2080, 100, 5, 'total test: 5, total test amount: 2080, total received: 100, received by: Dialab Pro', '2024-09-05 01:27:29', '2024-09-05 01:27:29'),
(114, 1, 6800, '[\"2\",\"49\",\"709\",\"710\",\"717\"]', 20240908, 665, 400, 5, 'total test: 5, total test amount: 665, total received: 400, received by: Dialab Pro', '2024-09-08 03:53:59', '2024-09-08 03:53:59'),
(115, 1, 6800, '[\"2\",\"49\",\"709\",\"710\",\"717\"]', 20240908, 665, 400, 5, 'total test: 5, total test amount: 665, total received: 400, received by: Dialab Pro', '2024-09-08 12:08:32', '2024-09-08 12:08:32'),
(116, 1, 6802, '[\"2\",\"709\",\"710\"]', 20240909, 150, 150, 3, 'total test: 3, total test amount: 150, total received: 150, received by: Dialab Pro', '2024-09-09 11:56:02', '2024-09-09 11:56:02'),
(117, 1, 6803, '[\"71\",\"49\",\"2\",\"710\",\"716\",\"717\",\"709\"]', 20240910, 1580, 1000, 7, 'total test: 7, total test amount: 1580, total received: 1000, received by: Dialab Pro', '2024-09-10 04:28:13', '2024-09-10 04:28:13'),
(118, 1, 6805, '[\"3\",\"9\",\"10\",\"3\",\"709\",\"710\",\"716\"]', 20240910, 1605, 500, 6, 'total test: 6, total test amount: 1605, total received: 500, received by: Dialab Pro', '2024-09-10 04:39:53', '2024-09-10 04:39:53'),
(119, 1, 6805, NULL, 20240910, 1995, 1105, NULL, 'total test: 6, total test amount: 1995, total received: 1105, received by: Dialab Pro', '2024-09-10 10:41:18', '2024-09-10 10:41:18'),
(120, 1, 6806, '[\"2\",\"709\",\"710\"]', 20240910, 180, 100, 3, 'total test: 3, total test amount: 180, total received: 100, received by: Dialab Pro', '2024-09-10 10:42:48', '2024-09-10 10:42:48'),
(121, 335, 6806, NULL, 20240910, 180, 80, NULL, 'total test: 3, total test amount: 180, total received: 80, received by: Babor', '2024-09-10 10:43:40', '2024-09-10 10:43:40'),
(122, 335, 6807, '[\"3\",\"5\",\"709\",\"710\"]', 20240910, 580, 200, 4, 'total test: 4, total test amount: 580, total received: 200, received by: Babor', '2024-09-10 10:46:17', '2024-09-10 10:46:17'),
(123, 338, 6807, NULL, 20240910, 430, 230, NULL, 'total test: 4, total test amount: 430, total received: 230, received by: riku', '2024-09-10 10:47:12', '2024-09-10 10:47:12'),
(124, 335, 6808, '[\"2\",\"9\",\"21\",\"709\",\"710\",\"716\"]', 20240910, 1495, 200, 6, 'total test: 6, total test amount: 1495, total received: 200, received by: Babor', '2024-09-10 10:51:05', '2024-09-10 10:51:05'),
(125, 335, 6808, NULL, 20240910, 1495, 295, NULL, 'total test: 6, total test amount: 1495, total received: 295, received by: Babor', '2024-09-10 10:51:18', '2024-09-10 10:51:18'),
(126, 338, 6808, NULL, 20240910, 1495, 500, NULL, 'total test: 6, total test amount: 1495, total received: 500, received by: riku', '2024-09-10 10:51:29', '2024-09-10 10:51:29'),
(127, 335, 6808, NULL, 20240910, 1495, 200, NULL, 'total test: 6, total test amount: 1495, total received: 200, received by: Babor', '2024-09-10 10:51:40', '2024-09-10 10:51:40'),
(128, 338, 6808, NULL, 20240910, 1495, 150, NULL, 'total test: 6, total test amount: 1495, total received: 150, received by: riku', '2024-09-10 10:51:55', '2024-09-10 10:51:55'),
(129, 335, 6808, NULL, 20240910, 1495, 150, NULL, 'total test: 6, total test amount: 1495, total received: 150, received by: Babor', '2024-09-10 10:52:02', '2024-09-10 10:52:02'),
(130, 338, 6808, NULL, 20240910, 1495, 0, NULL, 'total test: 6, total test amount: 1495, total received: 000, received by: riku', '2024-09-10 10:53:05', '2024-09-10 10:53:05'),
(131, 1, 6808, '[\"2\",\"9\",\"21\",\"709\",\"710\",\"716\"]', 20240910, 1495, 200, 6, 'total test: 6, total test amount: 1495, total received: 200, received by: Dialab Pro', '2024-09-10 11:41:24', '2024-09-10 11:41:24'),
(132, 1, 6807, '[\"420\",\"710\",\"713\"]', 20240910, 1730, 0, 3, 'total test: 3, total test amount: 1730, total received: 0, received by: Dialab Pro', '2024-09-10 11:44:55', '2024-09-10 11:44:55'),
(133, 1, 6809, '[\"407\",\"71\",\"710\",\"716\"]', 20240912, 1245, 500, 4, 'total test: 4, total test amount: 1245, total received: 500, received by: Dialab Pro', '2024-09-12 00:43:51', '2024-09-12 00:43:51'),
(134, 1, 6810, '[\"2\",\"9\",\"71\",\"709\",\"710\",\"716\"]', 20240912, 1765, 500, 6, 'total test: 6, total test amount: 1765, total received: 500, received by: Dialab Pro', '2024-09-12 01:12:52', '2024-09-12 01:12:52'),
(135, 1, 6807, '[\"5\",\"709\",\"710\"]', 20240912, 330, 200, 3, 'total test: 3, total test amount: 330, total received: 200, received by: Dialab Pro', '2024-09-12 01:16:20', '2024-09-12 01:16:20'),
(136, 1, 6812, '[\"49\",\"710\",\"717\"]', 20240913, 650, 500, 3, 'total test: 3, total test amount: 650, total received: 500, received by: Dialab Pro', '2024-09-12 12:24:09', '2024-09-12 12:24:09'),
(137, 1, 6814, '[\"71\",\"49\",\"710\",\"716\",\"717\"]', 20240914, 1415, 500, 5, 'total test: 5, total test amount: 1415, total received: 500, received by: Dialab Pro', '2024-09-14 01:11:58', '2024-09-14 01:11:58'),
(138, 1, 6815, '[\"2\",\"5\",\"9\",\"709\",\"710\",\"716\"]', 20240914, 1095, 500, 6, 'total test: 6, total test amount: 1095, total received: 500, received by: Dialab Pro', '2024-09-14 01:13:29', '2024-09-14 01:13:29'),
(139, 1, 6816, '[\"58\",\"51\",\"50\",\"434\",\"104\",\"710\",\"713\"]', 20240914, 1430, 300, 7, 'total test: 7, total test amount: 1430, total received: 300, received by: Dialab Pro', '2024-09-14 01:24:33', '2024-09-14 01:24:33'),
(140, 1, 6818, '[\"3\",\"709\",\"710\"]', 20240914, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2024-09-14 01:32:39', '2024-09-14 01:32:39'),
(141, 1, 6819, '[\"71\",\"49\",\"2\",\"710\",\"716\",\"717\",\"709\"]', 20240914, 1640, 500, 7, 'total test: 7, total test amount: 1640, total received: 500, received by: Dialab Pro', '2024-09-14 01:37:03', '2024-09-14 01:37:03'),
(142, 1, 6809, '[\"2\",\"3\"]', 20240914, 255, 255, 2, 'total test: 2, total test amount: 255, total received: 255, received by: Dialab Pro', '2024-09-14 04:23:35', '2024-09-14 04:23:35'),
(143, 1, 6807, '[\"2\",\"3\",\"5\",\"9\",\"709\",\"710\",\"716\"]', 20240915, 1405, 1360, 7, 'total test: 7, total test amount: 1405, total received: 1360, received by: Dialab Pro', '2024-09-14 23:28:14', '2024-09-14 23:28:14'),
(144, 1, 6820, '[\"48\",\"710\",\"717\"]', 20240915, 450, NULL, 3, 'total test: 3, total test amount: 450, total received: , received by: Dialab Pro', '2024-09-15 07:29:25', '2024-09-15 07:29:25'),
(145, 1, 6821, '[\"41\"]', 20240915, 1200, 200, 1, 'total test: 1, total test amount: 1200, total received: 200, received by: Dialab Pro', '2024-09-15 11:44:55', '2024-09-15 11:44:55'),
(146, 1, 6822, '[\"2\",\"709\",\"710\"]', 20240916, 180, NULL, 3, 'total test: 3, total test amount: 180, total received: , received by: Dialab Pro', '2024-09-15 21:40:29', '2024-09-15 21:40:29'),
(147, 1, 6823, '[\"104\",\"62\",\"120\",\"710\",\"713\"]', 20240916, 700, 500, 5, 'total test: 5, total test amount: 700, total received: 500, received by: Dialab Pro', '2024-09-16 01:08:39', '2024-09-16 01:08:39'),
(148, 1, 6824, '[\"71\",\"49\",\"2\",\"710\",\"716\",\"717\",\"709\"]', 20240916, 1640, 500, 7, 'total test: 7, total test amount: 1640, total received: 500, received by: Dialab Pro', '2024-09-16 07:38:56', '2024-09-16 07:38:56'),
(149, 1, 6825, '[\"407\",\"71\",\"434\",\"710\",\"716\"]', 20240916, 1395, 1000, 5, 'total test: 5, total test amount: 1395, total received: 1000, received by: Dialab Pro', '2024-09-16 09:46:14', '2024-09-16 09:46:14'),
(150, 1, 6826, '[\"48\",\"13\",\"611\",\"710\",\"717\",\"716\"]', 20240916, 2075, 2000, 6, 'total test: 6, total test amount: 2075, total received: 2000, received by: Dialab Pro', '2024-09-16 09:50:24', '2024-09-16 09:50:24'),
(151, 1, 6827, '[\"5\",\"10\",\"709\",\"710\",\"716\"]', 20240916, 1165, 1000, 5, 'total test: 5, total test amount: 1165, total received: 1000, received by: Dialab Pro', '2024-09-16 09:52:21', '2024-09-16 09:52:21'),
(152, 1, 6807, '[\"3\",\"709\",\"710\"]', 20240916, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2024-09-16 10:03:31', '2024-09-16 10:03:31'),
(153, 1, 6807, '[\"3\",\"5\",\"709\",\"710\"]', 20240917, 580, 200, 4, 'total test: 4, total test amount: 580, total received: 200, received by: Dialab Pro', '2024-09-17 05:18:57', '2024-09-17 05:18:57'),
(154, 1, 6807, '[\"2\",\"709\",\"710\"]', 20240919, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2024-09-18 13:33:02', '2024-09-18 13:33:02'),
(155, 1, 6828, '[\"2\",\"71\",\"709\",\"710\",\"716\"]', 20240920, 1095, 500, 5, 'total test: 5, total test amount: 1095, total received: 500, received by: Dialab Pro', '2024-09-20 00:20:29', '2024-09-20 00:20:29'),
(156, 1, 6829, '[\"71\",\"49\",\"72\",\"710\",\"716\",\"717\"]', 20240921, 2565, 1000, 6, 'total test: 6, total test amount: 2565, total received: 1000, received by: Dialab Pro', '2024-09-21 01:06:35', '2024-09-21 01:06:35'),
(157, 1, 6807, '[\"2\",\"709\",\"710\"]', 20240929, 143, 100, 3, 'total test: 3, total test amount: 143, total received: 100, received by: Dialab Pro', '2024-09-29 10:11:14', '2024-09-29 10:11:14'),
(158, 1, 6831, '[\"2\",\"9\",\"709\",\"710\",\"716\"]', 20241004, 900, 200, 5, 'total test: 5, total test amount: 900, total received: 200, received by: Dialab Pro', '2024-10-04 00:47:24', '2024-10-04 00:47:24'),
(159, 1, 6831, NULL, 20241004, 995, 700, NULL, 'total test: 5, total test amount: 995, total received: 700, received by: Dialab Pro', '2024-10-04 00:47:51', '2024-10-04 00:47:51'),
(160, 1, 6833, '[\"2\",\"709\",\"710\"]', 20241014, 100, 60, 3, 'total test: 3, total test amount: 100, total received: 60, received by: Dialab Pro', '2024-10-14 02:05:25', '2024-10-14 02:05:25'),
(161, 1, 6833, '[\"2\",\"709\",\"710\"]', 20241014, 100, 60, 3, 'total test: 3, total test amount: 100, total received: 60, received by: Dialab Pro', '2024-10-14 02:05:35', '2024-10-14 02:05:35'),
(162, 1, 6833, '[\"2\",\"709\",\"710\"]', 20241014, 100, 120, 3, 'total test: 3, total test amount: 100, total received: 120, received by: Dialab Pro', '2024-10-14 02:07:52', '2024-10-14 02:07:52'),
(163, 1, 6833, '[\"2\",\"709\",\"710\"]', 20241014, 100, 300, 3, 'total test: 3, total test amount: 100, total received: 300, received by: Dialab Pro', '2024-10-14 07:49:01', '2024-10-14 07:49:01'),
(164, 1, 6834, '[\"2\",\"709\",\"710\"]', 20241014, 105, 50, 3, 'total test: 3, total test amount: 105, total received: 50, received by: Dialab Pro', '2024-10-14 11:47:38', '2024-10-14 11:47:38'),
(165, 1, 6834, '[\"2\",\"709\",\"710\"]', 20241014, 105, 50, 3, 'total test: 3, total test amount: 105, total received: 50, received by: Dialab Pro', '2024-10-14 11:48:02', '2024-10-14 11:48:02'),
(166, 1, 6834, '[\"2\",\"709\",\"710\"]', 20241014, 105, 50, 3, 'total test: 3, total test amount: 105, total received: 50, received by: Dialab Pro', '2024-10-14 11:48:14', '2024-10-14 11:48:14'),
(167, 1, 6835, '[\"71\",\"2\",\"49\",\"710\",\"716\",\"709\",\"717\"]', 20241015, 1640, 500, 7, 'total test: 7, total test amount: 1640, total received: 500, received by: Dialab Pro', '2024-10-14 23:18:43', '2024-10-14 23:18:43'),
(168, 1, 6834, '[\"2\",\"10\",\"709\",\"710\",\"716\"]', 20241015, 1100, 500, 5, 'total test: 5, total test amount: 1100, total received: 500, received by: Dialab Pro', '2024-10-17 03:43:31', '2024-10-17 03:43:31'),
(169, 1, 6837, '[\"3\",\"10\",\"26\",\"709\",\"710\",\"716\"]', 20241017, 1600, 600, 6, 'total test: 6, total test amount: 1600, total received: 600, received by: Dialab Pro', '2024-10-17 03:45:53', '2024-10-17 03:45:53'),
(170, 1, 6837, '[\"3\",\"10\",\"26\",\"709\",\"710\",\"716\"]', 20241017, 1599.99994, 600, 6, 'total test: 6, total test amount: 1599.99994, total received: 600, received by: Dialab Pro', '2024-10-17 03:46:08', '2024-10-17 03:46:08'),
(171, 1, 6837, '[\"41\"]', 20241017, 1200, NULL, 1, 'total test: 1, total test amount: 1200, total received: , received by: Dialab Pro', '2024-10-17 05:15:33', '2024-10-17 05:15:33'),
(172, 1, 6838, '[\"3\",\"10\",\"709\",\"710\",\"716\"]', 20241018, 965, 500, 5, 'total test: 5, total test amount: 965, total received: 500, received by: Dialab Pro', '2024-10-18 04:28:41', '2024-10-18 04:28:41'),
(173, 1, 6838, '[\"3\",\"709\",\"710\",\"10\",\"709\",\"710\",\"716\"]', 20241018, 620, 120, 7, 'refund test: 7, total test amount: 620, total refund: 120, refund by: Dialab Pro', '2024-10-18 04:30:22', '2024-10-18 04:30:22'),
(174, 1, 6839, '[\"5\",\"10\",\"39\",\"709\",\"710\",\"716\"]', 20241016, 1530, 500, 6, 'total test: 6, total test amount: 1530, total received: 500, received by: Dialab Pro', '2024-10-18 04:34:27', '2024-10-18 04:34:27'),
(175, 1, 6839, '[\"5\",\"10\",\"710\",\"716\",\"39\",\"709\",\"710\",\"716\"]', 20241016, 1330, 830, 8, 'refund test: 8, total test amount: 1330, total refund: 830, refund by: Dialab Pro', '2024-10-18 04:36:05', '2024-10-18 04:36:05'),
(176, 1, 6840, '[\"3\",\"9\",\"18\",\"709\",\"710\",\"716\"]', 20241018, 1260, 500, 6, 'total test: 6, total test amount: 1260, total received: 500, received by: Dialab Pro', '2024-10-18 04:44:32', '2024-10-18 04:44:32'),
(177, 1, 6840, '[\"3\",\"709\",\"710\",\"9\",\"18\",\"709\",\"710\",\"716\"]', 20241018, 620, 120, 8, 'refund test: 8, total test amount: 620, total refund: 120, refund by: Dialab Pro', '2024-10-18 04:45:03', '2024-10-18 04:45:03'),
(178, 1, 6841, '[\"41\"]', 20241021, 1080, 500, 1, 'total test: 1, total test amount: 1080, total received: 500, received by: Dialab Pro', '2024-10-21 04:23:22', '2024-10-21 04:23:22'),
(179, 1, 6842, '[\"2\",\"49\",\"5\",\"10\",\"709\",\"710\",\"717\",\"716\"]', 20241022, 1800, NULL, 8, 'total test: 8, total test amount: 1800, total received: , received by: Dialab Pro', '2024-10-22 01:46:31', '2024-10-22 01:46:31'),
(180, 1, 6842, '[\"41\"]', 20241022, 960, 500, 1, 'total test: 1, total test amount: 960, total received: 500, received by: Dialab Pro', '2024-10-22 03:08:22', '2024-10-22 03:08:22'),
(181, 1, 6843, '[\"49\",\"71\",\"710\",\"717\",\"716\"]', 20241023, 1865, 1000, 5, 'total test: 5, total test amount: 1865, total received: 1000, received by: Dialab Pro', '2024-10-23 02:50:55', '2024-10-23 02:50:55'),
(182, 1, 6841, '[\"41\"]', 20241023, 1200, NULL, 1, 'total test: 1, total test amount: 1200, total received: , received by: Dialab Pro', '2024-10-23 02:53:46', '2024-10-23 02:53:46'),
(183, 1, 6844, '[\"2\",\"49\",\"71\",\"709\",\"710\",\"717\",\"716\"]', 20241028, 1640, 500, 7, 'total test: 7, total test amount: 1640, total received: 500, received by: Dialab Pro', '2024-10-28 10:50:07', '2024-10-28 10:50:07'),
(184, 1, 6844, NULL, 20241028, 2030, 1140, NULL, 'total test: 7, total test amount: 2030, total received: 1140, received by: Dialab Pro', '2024-10-28 11:10:42', '2024-10-28 11:10:42'),
(185, 1, 6846, '[\"5\",\"709\",\"710\"]', 20241103, 30, NULL, 3, 'total test: 3, total test amount: 30, total received: , received by: Dialab Pro', '2024-11-03 07:43:00', '2024-11-03 07:43:00'),
(186, 1, 6848, '[\"41\"]', 20241103, 0, NULL, 1, 'total test: 1, total test amount: 0, total received: , received by: Dialab Pro', '2024-11-03 09:18:07', '2024-11-03 09:18:07'),
(187, 1, 6849, '[\"113\",\"710\",\"716\"]', 20241103, 30, NULL, 3, 'total test: 3, total test amount: 30, total received: , received by: Dialab Pro', '2024-11-03 10:25:13', '2024-11-03 10:25:13'),
(188, 1, 6850, '[\"16\",\"710\",\"716\"]', 20241103, 310, NULL, 3, 'total test: 3, total test amount: 310, total received: , received by: Dialab Pro', '2024-11-03 10:39:10', '2024-11-03 10:39:10'),
(189, 1, 6852, '[\"48\",\"367\",\"710\",\"717\"]', 20241105, 750, NULL, 4, 'total test: 4, total test amount: 750, total received: , received by: Dialab Pro', '2024-11-05 06:02:17', '2024-11-05 06:02:17'),
(190, 1, 6857, '[\"407\"]', 20241112, 140, 140, 1, 'total test: 1, total test amount: 140, total received: 140, received by: Dialab Pro', '2024-11-12 05:53:34', '2024-11-12 05:53:34'),
(191, 1, 6866, '[\"407\",\"41\",\"71\",\"13\",\"77\",\"23\",\"710\",\"716\"]', 20241112, 3540, 3540, 8, 'total test: 8, total test amount: 3540, total received: 3540, received by: Dialab Pro', '2024-11-12 07:15:42', '2024-11-12 07:15:42'),
(192, 1, 6867, '[\"41\"]', 20241112, 600, 600, 1, 'total test: 1, total test amount: 600, total received: 600, received by: Dialab Pro', '2024-11-12 08:25:29', '2024-11-12 08:25:29'),
(193, 1, 6868, '[\"48\",\"62\",\"41\",\"13\",\"710\",\"717\",\"716\"]', 20241112, 1806, 1800, 7, 'total test: 7, total test amount: 1806, total received: 1800, received by: Dialab Pro', '2024-11-12 08:30:39', '2024-11-12 08:30:39'),
(194, 1, 6870, '[\"48\",\"42\",\"71\",\"407\",\"35\",\"62\",\"710\",\"717\",\"716\",\"713\"]', 20241112, 2940, 2940, 10, 'total test: 10, total test amount: 2940, total received: 2940, received by: Dialab Pro', '2024-11-12 08:46:59', '2024-11-12 08:46:59'),
(195, 1, 6871, '[\"48\",\"62\",\"41\",\"71\",\"96\",\"710\",\"717\",\"716\"]', 20241112, 2500, 500, 8, 'total test: 8, total test amount: 2500, total received: 500, received by: Dialab Pro', '2024-11-12 08:59:43', '2024-11-12 08:59:43'),
(196, 1, 6872, '[\"41\",\"71\",\"710\",\"716\"]', 20241112, 1080, 1080, 4, 'total test: 4, total test amount: 1080, total received: 1080, received by: Dialab Pro', '2024-11-12 09:09:46', '2024-11-12 09:09:46'),
(197, 1, 6873, '[\"13\",\"710\",\"716\"]', 20241112, 380, NULL, 3, 'total test: 3, total test amount: 380, total received: , received by: Dialab Pro', '2024-11-12 09:55:10', '2024-11-12 09:55:10'),
(198, 341, 6881, '[\"48\",\"367\",\"710\",\"717\"]', 20241113, 730, 730, 4, 'total test: 4, total test amount: 730, total received: 730, received by: Happy', '2024-11-13 02:09:58', '2024-11-13 02:09:58'),
(199, 338, 6885, '[\"349\"]', 20241113, 600, 600, 1, 'total test: 1, total test amount: 600, total received: 600, received by: Akhi', '2024-11-13 04:57:48', '2024-11-13 04:57:48'),
(200, 338, 6887, '[\"71\",\"75\",\"73\",\"710\",\"716\"]', 20241113, 3000, 1000, 5, 'total test: 5, total test amount: 3000, total received: 1000, received by: Akhi', '2024-11-13 05:23:10', '2024-11-13 05:23:10'),
(201, 342, 6888, '[\"48\",\"407\",\"13\",\"71\",\"77\",\"62\",\"611\",\"104\",\"9\",\"710\",\"717\",\"716\",\"713\"]', 20241113, 3390, 3390, 13, 'total test: 13, total test amount: 3390, total received: 3390, received by: Erani', '2024-11-13 06:03:11', '2024-11-13 06:03:11'),
(202, 342, 6890, '[\"48\",\"710\",\"717\"]', 20241113, 420, 400, 3, 'total test: 3, total test amount: 420, total received: 400, received by: Erani', '2024-11-13 07:13:43', '2024-11-13 07:13:43'),
(203, 335, 6891, '[\"41\"]', 20241113, 840, 840, 1, 'total test: 1, total test amount: 840, total received: 840, received by: Tanusree', '2024-11-13 07:50:36', '2024-11-13 07:50:36'),
(204, 335, 6892, '[\"23\",\"48\",\"710\",\"716\",\"717\"]', 20241113, 1210, 1210, 5, 'total test: 5, total test amount: 1210, total received: 1210, received by: Tanusree', '2024-11-13 07:57:53', '2024-11-13 07:57:53'),
(205, 335, 6894, '[\"41\",\"407\",\"62\",\"48\",\"710\",\"717\"]', 20241113, 1000, 500, 6, 'total test: 6, total test amount: 1000, total received: 500, received by: Tanusree', '2024-11-13 09:23:28', '2024-11-13 09:23:28'),
(206, 335, 6868, NULL, 20241112, 2465, 6, NULL, 'total test: 7, total test amount: 2465, total received: 6, received by: Tanusree', '2024-11-13 09:52:04', '2024-11-13 09:52:04'),
(207, 335, 6871, NULL, 20241112, 3565, 2000, NULL, 'total test: 8, total test amount: 3565, total received: 2000, received by: Tanusree', '2024-11-13 09:52:44', '2024-11-13 09:52:44'),
(208, 335, 6873, NULL, 20241112, 530, 380, NULL, 'total test: 3, total test amount: 530, total received: 380, received by: Tanusree', '2024-11-13 09:53:00', '2024-11-13 09:53:00'),
(209, 341, 6899, '[\"48\",\"41\",\"407\",\"23\",\"71\",\"62\",\"710\",\"717\",\"716\"]', 20241114, 3610, 500, 9, 'total test: 9, total test amount: 3610, total received: 500, received by: Happy', '2024-11-13 23:02:21', '2024-11-13 23:02:21'),
(210, 338, 6900, '[\"48\",\"710\",\"717\"]', 20241114, 420, 300, 3, 'total test: 3, total test amount: 420, total received: 300, received by: Akhi', '2024-11-13 23:48:56', '2024-11-13 23:48:56'),
(211, 342, 6902, '[\"367\"]', 20241114, 300, 300, 1, 'total test: 1, total test amount: 300, total received: 300, received by: Erani', '2024-11-14 01:44:55', '2024-11-14 01:44:55'),
(212, 342, 6904, '[\"49\",\"62\",\"13\",\"407\",\"104\",\"120\",\"39\",\"105\",\"710\",\"717\",\"716\",\"713\"]', 20241114, 3140, 3140, 12, 'total test: 12, total test amount: 3140, total received: 3140, received by: Erani', '2024-11-14 02:49:56', '2024-11-14 02:49:56'),
(213, 1, 6905, '[\"48\",\"407\",\"41\",\"23\",\"710\",\"717\",\"716\"]', 20241113, 2130, 1530, 7, 'total test: 7, total test amount: 2130, total received: 1530, received by: Dialab Pro', '2024-11-15 05:53:12', '2024-11-15 05:53:12'),
(214, 1, 6905, NULL, 20241113, 3130, 600, NULL, 'total test: 7, total test amount: 3130, total received: 600, received by: Dialab Pro', '2024-11-15 05:55:15', '2024-11-15 05:55:15'),
(215, 1, 6906, '[\"349\"]', 20241116, 600, NULL, 1, 'total test: 1, total test amount: 600, total received: , received by: Dialab Pro', '2024-11-16 04:40:23', '2024-11-16 04:40:23'),
(216, 1, 6907, '[\"71\",\"48\",\"710\",\"716\",\"717\"]', 20241121, 1195, 500, 5, 'total test: 5, total test amount: 1195, total received: 500, received by: Dialab Pro', '2024-11-21 07:00:41', '2024-11-21 07:00:41'),
(217, 1, 6908, '[\"2\",\"5\",\"709\",\"710\"]', 20241123, 560, 200, 4, 'total test: 4, total test amount: 560, total received: 200, received by: Dialab Pro', '2024-11-23 07:08:44', '2024-11-23 07:08:44'),
(218, 1, 6908, '[\"2\",\"5\",\"16\",\"709\",\"710\",\"716\"]', 20241123, 930, 300, 6, 'total test: 6, total test amount: 930, total received: 300, received by: Dialab Pro', '2024-11-23 07:09:14', '2024-11-23 07:09:14'),
(219, 1, 6908, '[\"2\",\"16\",\"709\",\"710\",\"716\"]', 20241123, 570, 200, 5, 'total test: 5, total test amount: 570, total received: 200, received by: Dialab Pro', '2024-11-24 12:59:34', '2024-11-24 12:59:34'),
(220, 1, 6908, '[\"2\",\"16\",\"709\",\"710\",\"716\"]', 20241123, 570, 570, 5, 'total test: 5, total test amount: 570, total received: 570, received by: Dialab Pro', '2024-11-24 12:59:57', '2024-11-24 12:59:57'),
(221, 1, 6910, '[\"2\",\"409\",\"709\",\"710\"]', 20241127, 1420, NULL, 4, 'total test: 4, total test amount: 1420, total received: , received by: Dialab Pro', '2024-11-27 08:06:43', '2024-11-27 08:06:43'),
(222, 1, 6911, '[\"9\",\"710\",\"716\"]', 20241127, 820, 820, 3, 'total test: 3, total test amount: 820, total received: 820, received by: Dialab Pro', '2024-11-27 08:13:04', '2024-11-27 08:13:04'),
(223, 1, 6910, '[\"2\",\"409\",\"709\",\"710\"]', 20241127, 1420, 0, 4, 'total test: 4, total test amount: 1420, total received: 0, received by: Dialab Pro', '2024-12-02 02:50:10', '2024-12-02 02:50:10'),
(224, 1, 6912, '[\"2\",\"5\",\"16\",\"30\",\"58\",\"709\",\"710\",\"716\"]', 20241209, 1990, 1000, 8, 'total test: 8, total test amount: 1990, total received: 1000, received by: Dialab Pro', '2024-12-09 03:10:24', '2024-12-09 03:10:24'),
(225, 1, 6913, '[\"2\",\"71\",\"709\",\"710\",\"716\"]', 20241217, 910, 500, 5, 'total test: 5, total test amount: 910, total received: 500, received by: Dialab Pro', '2024-12-17 04:23:55', '2024-12-17 04:23:55'),
(226, 1, 6915, '[\"71\",\"407\",\"710\",\"716\"]', 20241218, 900, 500, 4, 'total test: 4, total test amount: 900, total received: 500, received by: Dialab Pro', '2024-12-17 12:21:05', '2024-12-17 12:21:05'),
(227, 1, 6916, '[\"2\",\"96\",\"709\",\"710\",\"716\"]', 20241223, 750, 750, 5, 'total test: 5, total test amount: 750, total received: 750, received by: Dialab Pro', '2024-12-23 01:24:17', '2024-12-23 01:24:17'),
(228, 1, 6917, '[\"2\",\"9\",\"709\",\"710\",\"716\"]', 20241224, 830, 500, 5, 'total test: 5, total test amount: 830, total received: 500, received by: Dialab Pro', '2024-12-24 00:58:57', '2024-12-24 00:58:57'),
(229, 1, 6915, '[\"71\",\"407\",\"710\",\"716\"]', 20241218, 900, 600, 4, 'total test: 4, total test amount: 900, total received: 600, received by: Dialab Pro', '2025-01-05 11:24:52', '2025-01-05 11:24:52'),
(230, 1, 6918, '[\"48\",\"710\",\"717\"]', 20250116, 420, 400, 3, 'total test: 3, total test amount: 420, total received: 400, received by: Dialab Pro', '2025-01-16 00:16:53', '2025-01-16 00:16:53'),
(231, 1, 6919, '[\"2\",\"343\",\"709\",\"710\"]', 20250116, 1620, 1620, 4, 'total test: 4, total test amount: 1620, total received: 1620, received by: Dialab Pro', '2025-01-16 01:20:33', '2025-01-16 01:20:33'),
(232, 1, 6918, NULL, 20250116, 420, 20, NULL, 'total test: 3, total test amount: 420, total received: 20, received by: Dialab Pro', '2025-01-16 01:21:57', '2025-01-16 01:21:57'),
(233, 1, 6920, '[\"9\",\"710\",\"716\"]', 20250116, 820, 0, 3, 'total test: 3, total test amount: 820, total received: 0, received by: Dialab Pro', '2025-01-16 09:44:59', '2025-01-16 09:44:59'),
(234, 1, 6921, '[\"9\",\"10\",\"710\",\"716\"]', 20250116, 2220, 2000, 4, 'total test: 4, total test amount: 2220, total received: 2000, received by: Dialab Pro', '2025-01-16 09:47:00', '2025-01-16 09:47:00'),
(235, 1, 6921, '[\"9\",\"10\",\"710\",\"716\"]', 20250116, 2220, 2000, 4, 'total test: 4, total test amount: 2220, total received: 2000, received by: Dialab Pro', '2025-01-25 02:24:17', '2025-01-25 02:24:17'),
(236, 1, 6905, NULL, 20241113, 3030, 500, NULL, 'total test: 7, total test amount: 3030, total received: 500, received by: Dialab Pro', '2025-01-26 05:17:34', '2025-01-26 05:17:34'),
(237, 1, 6924, '[\"42\"]', 20250126, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Dialab Pro', '2025-01-26 11:53:20', '2025-01-26 11:53:20'),
(238, 1, 6925, '[\"663\"]', 20250127, 800, NULL, 1, 'total test: 1, total test amount: 800, total received: , received by: Dialab Pro', '2025-01-27 01:40:14', '2025-01-27 01:40:14'),
(239, 1, 6926, '[\"2\",\"128\",\"709\",\"710\"]', 20250130, 620, 500, 4, 'total test: 4, total test amount: 620, total received: 500, received by: Dialab Pro', '2025-01-30 01:51:18', '2025-01-30 01:51:18'),
(240, 1, 6927, '[\"2\",\"5\",\"10\",\"35\",\"13\",\"709\",\"710\",\"716\",\"713\"]', 20250130, 3840, NULL, 9, 'total test: 9, total test amount: 3840, total received: , received by: Dialab Pro', '2025-01-30 02:06:53', '2025-01-30 02:06:53'),
(241, 1, 6928, '[\"2\",\"9\",\"10\",\"709\",\"710\",\"716\"]', 20250130, 2430, 500, 6, 'total test: 6, total test amount: 2430, total received: 500, received by: Dialab Pro', '2025-01-30 02:09:09', '2025-01-30 02:09:09');
INSERT INTO `user_logs` (`id`, `admin_id`, `patient_id`, `test_id`, `invoice`, `total_amount`, `received_amount`, `total_test`, `note`, `created_at`, `updated_at`) VALUES
(242, 1, 6929, '[\"2\",\"5\",\"10\",\"709\",\"710\",\"716\"]', 20250205, 2030, 500, 6, 'total test: 6, total test amount: 2030, total received: 500, received by: Dialab Pro', '2025-02-05 08:58:14', '2025-02-05 08:58:14'),
(243, 1, 6930, '[\"2\",\"709\",\"710\"]', 20250205, 220, 50, 3, 'total test: 3, total test amount: 220, total received: 50, received by: Dialab Pro', '2025-02-05 09:10:57', '2025-02-05 09:10:57'),
(244, 1, 6931, '[\"407\",\"48\",\"710\",\"717\"]', 20250206, 570, 300, 4, 'total test: 4, total test amount: 570, total received: 300, received by: Dialab Pro', '2025-02-06 03:31:31', '2025-02-06 03:31:31'),
(245, 1, 6931, NULL, 20250206, 600, 250, NULL, 'total test: 4, total test amount: 600, total received: 250, received by: Dialab Pro', '2025-02-06 03:32:15', '2025-02-06 03:32:15'),
(246, 1, 6932, '[\"3\",\"5\",\"709\",\"710\"]', 20250206, 512, 200, 4, 'total test: 4, total test amount: 512, total received: 200, received by: Dialab Pro', '2025-02-06 03:53:28', '2025-02-06 03:53:28'),
(247, 1, 6932, NULL, 20250206, 520, 212, NULL, 'total test: 4, total test amount: 520, total received: 212, received by: Dialab Pro', '2025-02-06 03:57:38', '2025-02-06 03:57:38'),
(248, 1, 6933, '[\"407\",\"48\",\"71\",\"41\",\"120\",\"710\",\"717\",\"716\"]', 20250216, 2580, 1500, 8, 'total test: 8, total test amount: 2580, total received: 1500, received by: Dialab Pro', '2025-02-16 01:00:28', '2025-02-16 01:00:28'),
(249, 1, 6934, '[\"5\",\"10\",\"709\",\"710\",\"716\"]', 20250216, 1730, 500, 5, 'total test: 5, total test amount: 1730, total received: 500, received by: Dialab Pro', '2025-02-16 01:04:28', '2025-02-16 01:04:28'),
(250, 1, 6935, '[\"49\",\"13\",\"373\",\"41\",\"122\",\"710\",\"717\",\"716\"]', 20250216, 2730, NULL, 8, 'total test: 8, total test amount: 2730, total received: , received by: Dialab Pro', '2025-02-16 01:30:45', '2025-02-16 01:30:45'),
(251, 345, 6936, '[\"2\",\"48\",\"41\",\"39\",\"709\",\"710\",\"717\"]', 20250217, 1960, 1900, 7, 'total test: 7, total test amount: 1960, total received: 1900, received by: Sumon Gosh', '2025-02-17 00:23:41', '2025-02-17 00:23:41'),
(252, 345, 6936, '[\"2\",\"39\",\"41\",\"709\",\"710\",\"717\"]', 20250217, 1560, 1900, 6, 'total test: 6, total test amount: 1560, total received: 1900, received by: Sumon Gosh', '2025-02-17 00:27:24', '2025-02-17 00:27:24'),
(253, 345, 6940, '[\"2\",\"5\",\"10\",\"709\",\"710\",\"716\"]', 20250217, 1830, 1830, 6, 'total test: 6, total test amount: 1830, total received: 1830, received by: Sumon Gosh', '2025-02-17 00:54:55', '2025-02-17 00:54:55'),
(254, 345, 6929, NULL, 20250205, 2000, 1500, NULL, 'total test: 6, total test amount: 2000, total received: 1500, received by: Sumon Gosh', '2025-02-17 00:57:10', '2025-02-17 00:57:10'),
(255, 346, 6934, NULL, 20250216, 1800, 1200, NULL, 'total test: 5, total test amount: 1800, total received: 1200, received by: Rathin', '2025-02-17 01:21:55', '2025-02-17 01:21:55'),
(256, 346, 6930, NULL, 20250205, 220, 170, NULL, 'total test: 3, total test amount: 220, total received: 170, received by: Rathin', '2025-02-17 01:22:13', '2025-02-17 01:22:13'),
(257, 1, 6935, '[\"71\",\"710\",\"716\"]', 20250218, 370, NULL, 3, 'total test: 3, total test amount: 370, total received: , received by: Dialab Pro', '2025-02-18 02:28:12', '2025-02-18 02:28:12'),
(258, 1, 6940, '[\"49\",\"46\",\"105\",\"104\",\"710\",\"717\",\"716\",\"713\"]', 20250218, 2200, 2200, 8, 'total test: 8, total test amount: 2200, total received: 2200, received by: Dialab Pro', '2025-02-18 02:32:05', '2025-02-18 02:32:05'),
(259, 1, 6935, '[\"49\",\"74\",\"73\",\"46\",\"23\",\"19\",\"710\",\"717\",\"716\"]', 20250218, 5130, 5000, 9, 'total test: 9, total test amount: 5130, total received: 5000, received by: Dialab Pro', '2025-02-18 03:17:14', '2025-02-18 03:17:14'),
(260, 1, 6935, NULL, 20250218, 6130, 130, NULL, 'total test: 9, total test amount: 6130, total received: 130, received by: Dialab Pro', '2025-02-18 03:29:20', '2025-02-18 03:29:20'),
(261, 1, 6935, NULL, 20250218, 1220, 70, NULL, 'total test: 3, total test amount: 1220, total received: 70, received by: Dialab Pro', '2025-03-02 22:22:48', '2025-03-02 22:22:48'),
(262, 1, 6942, '[\"2\",\"9\",\"10\",\"19\",\"709\",\"710\",\"716\"]', 20250304, 2205, 1500, 7, 'total test: 7, total test amount: 2205, total received: 1500, received by: Dialab Pro', '2025-03-04 01:32:06', '2025-03-04 01:32:06'),
(263, 1, 6944, '[\"48\",\"71\",\"407\",\"710\",\"717\",\"716\"]', 20250311, 1480, 500, 6, 'total test: 6, total test amount: 1480, total received: 500, received by: Dialab Pro', '2025-03-11 00:12:26', '2025-03-11 00:12:26'),
(264, 1, 6946, '[\"71\",\"48\",\"710\",\"716\",\"717\"]', 20250315, 1330, 500, 5, 'total test: 5, total test amount: 1330, total received: 500, received by: Dialab Pro', '2025-03-15 03:22:20', '2025-03-15 03:22:20'),
(265, 1, 6948, '[\"48\",\"407\",\"71\",\"710\",\"717\",\"716\"]', 20250317, 1480, 1000, 6, 'total test: 6, total test amount: 1480, total received: 1000, received by: Dialab Pro', '2025-03-17 00:16:17', '2025-03-17 00:16:17'),
(266, 1, 6949, '[\"407\",\"49\",\"71\",\"710\",\"717\",\"716\"]', 20250317, 1755, 1000, 6, 'total test: 6, total test amount: 1755, total received: 1000, received by: Dialab Pro', '2025-03-17 10:59:12', '2025-03-17 10:59:12'),
(267, 1, 6941, '[\"5\",\"2\",\"709\",\"710\"]', 20250317, 560, 0, 4, 'total test: 4, total test amount: 560, total received: 0, received by: Dialab Pro', '2025-03-17 11:09:56', '2025-03-17 11:09:56'),
(268, 1, 6907, '[\"41\"]', 20250317, 1080, 500, 1, 'total test: 1, total test amount: 1080, total received: 500, received by: Dialab Pro', '2025-03-17 11:13:35', '2025-03-17 11:13:35'),
(269, 1, 6950, '[\"42\"]', 20250317, 1080, 500, 1, 'total test: 1, total test amount: 1080, total received: 500, received by: Dialab Pro', '2025-03-17 11:14:51', '2025-03-17 11:14:51'),
(270, 1, 6951, '[\"48\",\"710\",\"717\"]', 20250318, 420, NULL, 3, 'total test: 3, total test amount: 420, total received: , received by: Dialab Pro', '2025-03-17 12:17:30', '2025-03-17 12:17:30'),
(271, 1, 6952, '[\"407\",\"48\",\"710\",\"717\"]', 20250318, 520, 300, 4, 'total test: 4, total test amount: 520, total received: 300, received by: Dialab Pro', '2025-03-18 02:13:07', '2025-03-18 02:13:07'),
(272, 1, 6953, '[\"434\",\"433\",\"710\",\"713\"]', 20250319, 740, NULL, 4, 'total test: 4, total test amount: 740, total received: , received by: Dialab Pro', '2025-03-19 00:27:03', '2025-03-19 00:27:03'),
(273, 1, 6954, '[\"9\",\"12\",\"14\",\"710\",\"716\"]', 20250319, 1730, 1500, 5, 'total test: 5, total test amount: 1730, total received: 1500, received by: Dialab Pro', '2025-03-19 00:30:44', '2025-03-19 00:30:44'),
(274, 1, 6956, '[\"2\",\"3\",\"71\",\"120\",\"116\",\"709\",\"710\",\"716\"]', 20250321, 2070, 2000, 8, 'total test: 8, total test amount: 2070, total received: 2000, received by: Dialab Pro', '2025-03-21 06:33:42', '2025-03-21 06:33:42'),
(275, 1, 6957, '[\"71\",\"407\",\"49\",\"710\",\"716\",\"717\"]', 20250322, 1985, 1000, 6, 'total test: 6, total test amount: 1985, total received: 1000, received by: Dialab Pro', '2025-03-22 01:11:01', '2025-03-22 01:11:01'),
(276, 1, 6958, '[\"71\",\"48\",\"41\",\"710\",\"716\",\"717\"]', 20250323, 2470, 1000, 6, 'total test: 6, total test amount: 2470, total received: 1000, received by: Dialab Pro', '2025-03-23 07:17:35', '2025-03-23 07:17:35'),
(277, 1, 6959, '[\"2\",\"5\",\"709\",\"710\"]', 20250323, 570, 570, 4, 'total test: 4, total test amount: 570, total received: 570, received by: Dialab Pro', '2025-03-23 07:38:22', '2025-03-23 07:38:22'),
(278, 1, 6960, '[\"2\",\"71\",\"255\",\"248\",\"243\",\"298\",\"291\",\"709\",\"710\",\"716\"]', 20250403, 3591, 3590, 10, 'total test: 10, total test amount: 3591, total received: 3590, received by: Dialab Pro', '2025-04-02 22:55:11', '2025-04-02 22:55:11'),
(279, 1, 6962, '[\"3\",\"16\",\"35\",\"709\",\"710\",\"716\",\"713\"]', 20250416, 1500, 1000, 7, 'total test: 7, total test amount: 1500, total received: 1000, received by: Dialab Pro', '2025-04-16 04:20:03', '2025-04-16 04:20:03'),
(280, 1, 6963, '[\"71\",\"48\",\"710\",\"716\",\"717\"]', 20250422, 1030, 500, 5, 'total test: 5, total test amount: 1030, total received: 500, received by: Dialab Pro', '2025-04-22 07:32:08', '2025-04-22 07:32:08'),
(281, 1, 6912, '[\"41\",\"39\",\"120\",\"71\",\"710\",\"716\"]', 20250422, 2915, 1500, 6, 'total test: 6, total test amount: 2915, total received: 1500, received by: Dialab Pro', '2025-04-22 07:33:03', '2025-04-22 07:33:03'),
(282, 1, 6965, '[\"2\",\"5\",\"10\",\"16\",\"709\",\"710\",\"716\"]', 20250422, 1830, 1000, 7, 'total test: 7, total test amount: 1830, total received: 1000, received by: Dialab Pro', '2025-04-22 11:54:01', '2025-04-22 11:54:01'),
(283, 1, 6966, '[\"71\",\"41\",\"350\",\"39\",\"710\",\"716\"]', 20250422, 2445, 1500, 6, 'total test: 6, total test amount: 2445, total received: 1500, received by: Dialab Pro', '2025-04-22 11:55:08', '2025-04-22 11:55:08'),
(284, 1, 6967, '[\"62\"]', 20250423, 300, 200, 1, 'total test: 1, total test amount: 300, total received: 200, received by: Dialab Pro', '2025-04-22 12:02:13', '2025-04-22 12:02:13'),
(285, 1, 6941, '[\"48\",\"71\",\"407\",\"401\",\"19\",\"41\",\"120\",\"710\",\"717\",\"716\"]', 20250423, 3856, 500, 10, 'total test: 10, total test amount: 3856, total received: 500, received by: Dialab Pro', '2025-04-23 01:52:56', '2025-04-23 01:52:56'),
(286, 1, 6941, '[\"19\",\"41\",\"48\",\"71\",\"120\",\"401\",\"407\",\"710\",\"716\",\"717\"]', 20250423, 3856, 500, 10, 'total test: 10, total test amount: 3856, total received: 500, received by: Dialab Pro', '2025-04-23 01:54:26', '2025-04-23 01:54:26'),
(287, 1, 6951, '[\"48\",\"71\",\"407\",\"401\",\"19\",\"41\",\"120\"]', 20250423, 3826, 500, 7, 'total test: 7, total test amount: 3826, total received: 500, received by: Dialab Pro', '2025-04-23 03:03:44', '2025-04-23 03:03:44'),
(288, 1, 6968, '[\"748\",\"749\",\"407\",\"452\"]', 20250423, 980, 500, 4, 'total test: 4, total test amount: 980, total received: 500, received by: Dialab Pro', '2025-04-23 04:17:03', '2025-04-23 04:17:03'),
(289, 1, 6941, '[\"48\",\"71\",\"407\",\"401\",\"19\",\"41\",\"120\",\"710\",\"717\",\"716\"]', 20250423, 3856, 1000, 10, 'total test: 10, total test amount: 3856, total received: 1000, received by: Dialab Pro', '2025-04-23 04:31:18', '2025-04-23 04:31:18'),
(290, 1, 6941, '[\"48\",\"71\",\"407\",\"401\",\"19\",\"41\",\"120\",\"710\",\"717\",\"716\"]', 20250423, 3856, 1000, 10, 'total test: 10, total test amount: 3856, total received: 1000, received by: Dialab Pro', '2025-04-23 04:32:07', '2025-04-23 04:32:07'),
(291, 1, 6969, '[\"62\"]', 20250423, 300, 300, 1, 'total test: 1, total test amount: 300, total received: 300, received by: Dialab Pro', '2025-04-23 04:45:22', '2025-04-23 04:45:22'),
(292, 1, 6970, '[\"3\",\"10\",\"120\",\"709\",\"710\",\"716\"]', 20250423, 2230, 2000, 6, 'total test: 6, total test amount: 2230, total received: 2000, received by: Dialab Pro', '2025-04-23 04:46:27', '2025-04-23 04:46:27'),
(293, 1, 6912, '[\"62\"]', 20250423, 300, 300, 1, 'total test: 1, total test amount: 300, total received: 300, received by: Dialab Pro', '2025-04-23 05:36:46', '2025-04-23 05:36:46'),
(294, 1, 6973, '[\"2\",\"10\",\"709\",\"710\",\"716\"]', 20250425, 1230, 500, 5, 'total test: 5, total test amount: 1230, total received: 500, received by: Dialab Pro', '2025-04-24 13:21:05', '2025-04-24 13:21:05'),
(295, 1, 6974, '[\"2\",\"709\",\"710\"]', 20250425, 180, NULL, 3, 'total test: 3, total test amount: 180, total received: , received by: Dialab Pro', '2025-04-24 13:28:37', '2025-04-24 13:28:37'),
(296, 1, 6975, '[\"41\",\"120\",\"62\"]', 20250425, 2100, NULL, 3, 'total test: 3, total test amount: 2100, total received: , received by: Dialab Pro', '2025-04-25 05:29:15', '2025-04-25 05:29:15'),
(297, 1, 6976, '[\"10\",\"48\",\"71\",\"710\",\"716\",\"717\"]', 20250426, 2380, 1500, 6, 'total test: 6, total test amount: 2380, total received: 1500, received by: Dialab Pro', '2025-04-26 00:18:29', '2025-04-26 00:18:29'),
(298, 1, 6967, NULL, 20250423, 300, 100, NULL, 'total test: 1, total test amount: 300, total received: 100, received by: Dialab Pro', '2025-04-26 00:22:05', '2025-04-26 00:22:05'),
(299, 1, 6973, NULL, 20250425, 1630, 500, NULL, 'total test: 5, total test amount: 1630, total received: 500, received by: Dialab Pro', '2025-04-26 00:22:26', '2025-04-26 00:22:26'),
(300, 1, 6978, '[\"71\",\"48\",\"407\",\"41\",\"710\",\"716\",\"717\"]', 20250426, 2380, 1500, 7, 'total test: 7, total test amount: 2380, total received: 1500, received by: Dialab Pro', '2025-04-26 05:16:49', '2025-04-26 05:16:49'),
(301, 1, 6979, '[\"2\",\"10\",\"709\",\"710\",\"716\"]', 20250427, 1310, 500, 5, 'total test: 5, total test amount: 1310, total received: 500, received by: Dialab Pro', '2025-04-27 02:06:37', '2025-04-27 02:06:37'),
(302, 1, 6907, '[\"71\",\"710\",\"716\"]', 20250427, 1220, 1200, 3, 'total test: 3, total test amount: 1220, total received: 1200, received by: Dialab Pro', '2025-04-27 02:09:06', '2025-04-27 02:09:06'),
(303, 1, 6927, '[\"42\"]', 20250427, 1200, 1200, 1, 'total test: 1, total test amount: 1200, total received: 1200, received by: Dialab Pro', '2025-04-27 02:17:40', '2025-04-27 02:17:40'),
(304, 1, 6981, '[\"125\",\"49\",\"710\",\"717\"]', 20250427, 1200, 500, 4, 'total test: 4, total test amount: 1200, total received: 500, received by: Dialab Pro', '2025-04-27 04:42:42', '2025-04-27 04:42:42'),
(305, 1, 6983, '[\"3\",\"10\",\"709\",\"710\",\"716\"]', 20250429, 830, NULL, 5, 'total test: 5, total test amount: 830, total received: , received by: Dialab Pro', '2025-04-29 01:49:59', '2025-04-29 01:49:59'),
(306, 1, 6984, '[\"41\",\"39\",\"348\",\"71\",\"12\",\"48\",\"710\",\"716\",\"717\"]', 20250429, 3635, 1500, 9, 'total test: 9, total test amount: 3635, total received: 1500, received by: Dialab Pro', '2025-04-29 02:33:56', '2025-04-29 02:33:56'),
(307, 1, 6985, '[\"48\",\"407\",\"13\",\"96\",\"16\",\"19\",\"71\",\"39\",\"120\",\"41\",\"62\",\"58\",\"710\",\"717\",\"716\"]', 20250429, 6830, 6830, 15, 'total test: 15, total test amount: 6830, total received: 6830, received by: Dialab Pro', '2025-04-29 02:37:50', '2025-04-29 02:37:50'),
(308, 1, 6986, '[\"48\",\"407\",\"710\",\"717\"]', 20250429, 620, 620, 4, 'total test: 4, total test amount: 620, total received: 620, received by: Dialab Pro', '2025-04-29 02:47:06', '2025-04-29 02:47:06'),
(309, 1, 6987, '[\"41\"]', 20250429, 1100, 1100, 1, 'total test: 1, total test amount: 1100, total received: 1100, received by: Dialab Pro', '2025-04-29 02:56:21', '2025-04-29 02:56:21'),
(310, 1, 6988, '[\"71\",\"41\",\"710\",\"716\"]', 20250429, 2180, 1500, 4, 'total test: 4, total test amount: 2180, total received: 1500, received by: Dialab Pro', '2025-04-29 10:02:51', '2025-04-29 10:02:51'),
(311, 1, 6989, '[\"5\",\"709\",\"710\"]', 20250429, 340, 340, 3, 'total test: 3, total test amount: 340, total received: 340, received by: Dialab Pro', '2025-04-29 10:12:34', '2025-04-29 10:12:34'),
(312, 1, 6990, '[\"48\",\"71\",\"30\",\"710\",\"717\",\"716\"]', 20250429, 2430, 2000, 6, 'total test: 6, total test amount: 2430, total received: 2000, received by: Dialab Pro', '2025-04-29 10:27:38', '2025-04-29 10:27:38'),
(313, 1, 6992, '[\"41\"]', 20250430, 840, 400, 1, 'total test: 1, total test amount: 840, total received: 400, received by: Dialab Pro', '2025-04-30 03:28:23', '2025-04-30 03:28:23'),
(314, 1, 6910, '[\"2\"]', 20250430, 200, 200, 1, 'total test: 1, total test amount: 200, total received: 200, received by: Dialab Pro', '2025-04-30 03:31:11', '2025-04-30 03:31:11'),
(315, 1, 6993, '[\"105\"]', 20250430, 400, NULL, 1, 'total test: 1, total test amount: 400, total received: , received by: Dialab Pro', '2025-04-30 03:37:54', '2025-04-30 03:37:54'),
(316, 1, 6994, '[\"48\"]', 20250430, 400, 400, 1, 'total test: 1, total test amount: 400, total received: 400, received by: Dialab Pro', '2025-04-30 03:53:45', '2025-04-30 03:53:45'),
(317, 1, 6996, '[\"13\",\"407\"]', 20250430, 630, NULL, 2, 'total test: 2, total test amount: 630, total received: , received by: Dialab Pro', '2025-04-30 06:25:35', '2025-04-30 06:25:35'),
(318, 1, 6998, '[\"407\",\"13\",\"71\",\"62\",\"41\",\"48\"]', 20250501, 2870, NULL, 6, 'total test: 6, total test amount: 2870, total received: , received by: Dialab Pro', '2025-04-30 22:49:25', '2025-04-30 22:49:25'),
(319, 1, 6999, '[\"2\",\"9\",\"709\",\"710\",\"716\"]', 20250501, 930, 500, 5, 'total test: 5, total test amount: 930, total received: 500, received by: Dialab Pro', '2025-05-01 02:52:06', '2025-05-01 02:52:06'),
(320, 1, 7000, '[\"2\",\"709\",\"710\"]', 20250501, 180, 180, 3, 'total test: 3, total test amount: 180, total received: 180, received by: Dialab Pro', '2025-05-01 03:49:38', '2025-05-01 03:49:38'),
(321, 1, 7001, '[\"104\",\"710\",\"713\"]', 20250502, 100, 100, 3, 'total test: 3, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-02 04:39:25', '2025-05-02 04:39:25'),
(322, 1, 7002, '[\"104\",\"710\",\"713\"]', 20250502, 100, 100, 3, 'total test: 3, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-02 04:49:50', '2025-05-02 04:49:50'),
(323, 1, 7004, '[\"407\"]', 20250503, 100, 100, 1, 'total test: 1, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-03 00:53:29', '2025-05-03 00:53:29'),
(324, 1, 7006, '[\"116\"]', 20250505, 100, 100, 1, 'total test: 1, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-05 00:11:19', '2025-05-05 00:11:19'),
(325, 1, 7006, '[\"116\"]', 20250505, 100, 100, 1, 'total test: 1, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-05 02:08:55', '2025-05-05 02:08:55'),
(326, 1, 7008, '[\"62\"]', 20250508, 300, NULL, 1, 'total test: 1, total test amount: 300, total received: , received by: Dialab Pro', '2025-05-07 22:36:35', '2025-05-07 22:36:35'),
(327, 1, 7009, '[\"62\"]', 20250508, 300, NULL, 1, 'total test: 1, total test amount: 300, total received: , received by: Dialab Pro', '2025-05-07 22:39:07', '2025-05-07 22:39:07'),
(328, 1, 7010, '[\"62\"]', 20250508, 150, 150, 1, 'total test: 1, total test amount: 150, total received: 150, received by: Dialab Pro', '2025-05-07 22:48:04', '2025-05-07 22:48:04'),
(329, 1, 7011, '[\"2\",\"5\",\"709\",\"710\"]', 20250508, 720, 500, 4, 'total test: 4, total test amount: 720, total received: 500, received by: Dialab Pro', '2025-05-07 22:54:17', '2025-05-07 22:54:17'),
(330, 1, 7013, '[\"39\"]', 20250508, 400, 400, 1, 'total test: 1, total test amount: 400, total received: 400, received by: Dialab Pro', '2025-05-07 23:48:10', '2025-05-07 23:48:10'),
(331, 1, 7026, '[\"434\",\"30\",\"23\",\"404\",\"62\",\"710\",\"716\"]', 20250508, 2500, 0, 7, 'total test: 7, total test amount: 2500, total received: 0, received by: Dialab Pro', '2025-05-08 05:05:02', '2025-05-08 05:05:02'),
(332, 1, 7026, NULL, 20250508, 4620, 2500, NULL, 'total test: 7, total test amount: 4620, total received: 2500, received by: Dialab Pro', '2025-05-08 05:11:08', '2025-05-08 05:11:08'),
(333, 1, 7027, '[\"104\",\"710\",\"713\"]', 20250508, 100, 100, 3, 'total test: 3, total test amount: 100, total received: 100, received by: Dialab Pro', '2025-05-08 05:34:28', '2025-05-08 05:34:28'),
(334, 335, 7028, '[\"71\",\"710\",\"716\"]', 20250508, 220, NULL, 3, 'total test: 3, total test amount: 220, total received: , received by: Ashraful Islam Saymon', '2025-05-08 06:21:52', '2025-05-08 06:21:52'),
(335, 335, 7029, '[\"434\",\"407\",\"98\",\"13\",\"710\",\"716\"]', 20250508, 1000.0000000000001, 1000, 6, 'total test: 6, total test amount: 1000, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-08 07:23:39', '2025-05-08 07:23:39'),
(336, 335, 7031, '[\"434\",\"383\",\"710\",\"716\"]', 20250508, 1280, 1280, 4, 'total test: 4, total test amount: 1280, total received: 1280, received by: Ashraful Islam Saymon', '2025-05-08 07:36:53', '2025-05-08 07:36:53'),
(337, 335, 7032, '[\"71\",\"77\",\"540\",\"41\",\"710\",\"716\"]', 20250508, 5180, NULL, 6, 'total test: 6, total test amount: 5180, total received: , received by: Ashraful Islam Saymon', '2025-05-08 07:47:05', '2025-05-08 07:47:05'),
(338, 335, 7033, '[\"69\"]', 20250508, 1000, NULL, 1, 'total test: 1, total test amount: 1000, total received: , received by: Ashraful Islam Saymon', '2025-05-08 07:55:27', '2025-05-08 07:55:27'),
(339, 335, 7034, '[\"39\",\"23\",\"13\",\"710\",\"716\"]', 20250509, 1600, 1000, 5, 'total test: 5, total test amount: 1600, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-08 22:32:08', '2025-05-08 22:32:08'),
(340, 335, 7035, '[\"434\",\"407\",\"383\",\"58\",\"710\",\"716\"]', 20250509, 1499.9999999999998, 1500, 6, 'total test: 6, total test amount: 1500, total received: 1500, received by: Ashraful Islam Saymon', '2025-05-08 22:42:00', '2025-05-08 22:42:00'),
(341, 335, 7036, '[\"434\",\"407\",\"71\",\"96\",\"710\",\"716\"]', 20250509, 1980, NULL, 6, 'total test: 6, total test amount: 1980, total received: , received by: Ashraful Islam Saymon', '2025-05-08 23:50:24', '2025-05-08 23:50:24'),
(342, 335, 7037, '[\"434\",\"407\",\"13\",\"71\",\"710\",\"716\"]', 20250509, 1220, NULL, 6, 'total test: 6, total test amount: 1220, total received: , received by: Ashraful Islam Saymon', '2025-05-08 23:53:48', '2025-05-08 23:53:48'),
(343, 335, 7038, '[\"434\",\"407\",\"13\",\"23\",\"96\",\"710\",\"716\"]', 20250509, 1970, NULL, 7, 'total test: 7, total test amount: 1970, total received: , received by: Ashraful Islam Saymon', '2025-05-08 23:56:41', '2025-05-08 23:56:41'),
(344, 335, 7039, '[\"105\",\"62\",\"104\",\"19\",\"42\",\"13\",\"710\",\"716\",\"713\"]', 20250509, 1999.9999999999998, 1000, 9, 'total test: 9, total test amount: 2000, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-09 00:51:59', '2025-05-09 00:51:59'),
(345, 335, 7040, '[\"434\",\"407\",\"383\",\"13\",\"23\",\"710\",\"716\"]', 20250509, 2500, 2500, 7, 'total test: 7, total test amount: 2500, total received: 2500, received by: Ashraful Islam Saymon', '2025-05-09 01:04:19', '2025-05-09 01:04:19'),
(346, 335, 7039, '[\"116\"]', 20250509, 100, 100, 1, 'total test: 1, total test amount: 100, total received: 100, received by: Ashraful Islam Saymon', '2025-05-09 01:20:58', '2025-05-09 01:20:58'),
(347, 335, 7034, NULL, 20250509, 2620, 500, NULL, 'total test: 5, total test amount: 2620, total received: 500, received by: Ashraful Islam Saymon', '2025-05-09 01:24:32', '2025-05-09 01:24:32'),
(348, 335, 7041, '[\"13\",\"71\",\"19\",\"383\",\"710\",\"716\"]', 20250509, 2240, NULL, 6, 'total test: 6, total test amount: 2240, total received: , received by: Ashraful Islam Saymon', '2025-05-09 03:52:04', '2025-05-09 03:52:04'),
(349, 335, 7036, NULL, 20250509, 2740, 1900, NULL, 'total test: 6, total test amount: 2740, total received: 1900, received by: Ashraful Islam Saymon', '2025-05-09 04:03:25', '2025-05-09 04:03:25'),
(350, 335, 7042, '[\"434\",\"105\",\"102\",\"71\",\"62\",\"42\",\"710\",\"716\"]', 20250509, 2000, 2000, 8, 'total test: 8, total test amount: 2000, total received: 2000, received by: Ashraful Islam Saymon', '2025-05-09 04:11:44', '2025-05-09 04:11:44'),
(351, 335, 7037, NULL, 20250509, 2200, 1000, NULL, 'total test: 6, total test amount: 2200, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-09 04:21:56', '2025-05-09 04:21:56'),
(352, 335, 7038, NULL, 20250509, 3920, 1970, NULL, 'total test: 7, total test amount: 3920, total received: 1970, received by: Ashraful Islam Saymon', '2025-05-09 04:23:19', '2025-05-09 04:23:19'),
(353, 335, 7043, '[\"434\",\"407\",\"404\",\"13\",\"39\",\"710\",\"716\"]', 20250509, 1370, 1350, 7, 'total test: 7, total test amount: 1370, total received: 1350, received by: Ashraful Islam Saymon', '2025-05-09 04:27:16', '2025-05-09 04:27:16'),
(354, 335, 7043, NULL, 20250509, 2700, 0, NULL, 'total test: 7, total test amount: 2700, total received: 0, received by: Ashraful Islam Saymon', '2025-05-09 04:28:50', '2025-05-09 04:28:50'),
(355, 335, 7044, '[\"434\",\"13\",\"383\",\"23\",\"710\",\"716\"]', 20250509, 2120, NULL, 6, 'total test: 6, total test amount: 2120, total received: , received by: Ashraful Islam Saymon', '2025-05-09 05:11:08', '2025-05-09 05:11:08'),
(356, 335, 7045, '[\"383\",\"104\",\"30\",\"710\",\"716\",\"713\"]', 20250509, 3230, NULL, 6, 'total test: 6, total test amount: 3230, total received: , received by: Ashraful Islam Saymon', '2025-05-09 05:30:53', '2025-05-09 05:30:53'),
(357, 335, 7046, '[\"434\",\"13\",\"383\",\"407\",\"710\",\"716\"]', 20250509, 1470, NULL, 6, 'total test: 6, total test amount: 1470, total received: , received by: Ashraful Islam Saymon', '2025-05-09 05:35:54', '2025-05-09 05:35:54'),
(358, 335, 7041, NULL, 20250509, 3720, 2240, NULL, 'total test: 6, total test amount: 3720, total received: 2240, received by: Ashraful Islam Saymon', '2025-05-09 06:12:12', '2025-05-09 06:12:12'),
(359, 335, 7032, NULL, 20250508, 8440, 5000, NULL, 'total test: 6, total test amount: 8440, total received: 5000, received by: Ashraful Islam Saymon', '2025-05-09 07:25:53', '2025-05-09 07:25:53'),
(360, 335, 7039, NULL, 20250509, 3630, 1000, NULL, 'total test: 9, total test amount: 3630, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-10 22:27:57', '2025-05-10 22:27:57'),
(361, 335, 7033, NULL, 20250508, 1500, NULL, NULL, 'total test: 1, total test amount: 1500, total received: , received by: Ashraful Islam Saymon', '2025-05-11 23:21:33', '2025-05-11 23:21:33'),
(362, 335, 7033, NULL, 20250508, 1500, 500, NULL, 'total test: 1, total test amount: 1500, total received: 500, received by: Ashraful Islam Saymon', '2025-05-11 23:26:51', '2025-05-11 23:26:51'),
(363, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(364, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(365, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(366, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(367, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(368, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(369, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(370, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:07', '2025-05-11 23:28:07'),
(371, 335, 7033, NULL, 20250508, 1480, 480, NULL, 'total test: 1, total test amount: 1480, total received: 480, received by: Ashraful Islam Saymon', '2025-05-11 23:28:08', '2025-05-11 23:28:08'),
(372, 335, 7033, NULL, 20250508, 1180, 500, NULL, 'total test: 1, total test amount: 1180, total received: 500, received by: Ashraful Islam Saymon', '2025-05-11 23:43:26', '2025-05-11 23:43:26'),
(373, 335, 7047, '[\"407\"]', 20250514, 200, 200, 1, 'total test: 1, total test amount: 200, total received: 200, received by: Ashraful Islam Saymon', '2025-05-13 22:47:39', '2025-05-13 22:47:39'),
(374, 335, 7048, '[\"35\",\"710\",\"713\"]', 20250514, 670, NULL, 3, 'total test: 3, total test amount: 670, total received: , received by: Ashraful Islam Saymon', '2025-05-13 23:54:36', '2025-05-13 23:54:36'),
(375, 335, 7050, '[\"434\"]', 20250515, 300, 300, 1, 'total test: 1, total test amount: 300, total received: 300, received by: Ashraful Islam Saymon', '2025-05-15 00:19:04', '2025-05-15 00:19:04'),
(376, 335, 7052, '[\"434\",\"407\",\"104\",\"71\",\"62\",\"105\",\"42\",\"710\",\"713\",\"716\"]', 20250515, 3000, 3000, 10, 'total test: 10, total test amount: 3000, total received: 3000, received by: Ashraful Islam Saymon', '2025-05-15 03:05:28', '2025-05-15 03:05:28'),
(377, 335, 7052, '[\"73\",\"75\",\"710\",\"716\"]', 20250515, 1400, 1400, 4, 'total test: 4, total test amount: 1400, total received: 1400, received by: Ashraful Islam Saymon', '2025-05-15 04:16:36', '2025-05-15 04:16:36'),
(378, 335, 7053, '[\"434\",\"524\",\"62\",\"41\",\"710\",\"716\"]', 20250516, 2100, 2100, 6, 'total test: 6, total test amount: 2100, total received: 2100, received by: Ashraful Islam Saymon', '2025-05-15 23:27:02', '2025-05-15 23:27:02'),
(379, 1, 7053, '[\"434\",\"524\",\"62\",\"41\",\"710\",\"716\"]', 20250516, 2100, 2100, 6, 'total test: 6, total test amount: 2100, total received: 2100, received by: Dialab Pro', '2025-05-15 23:43:25', '2025-05-15 23:43:25'),
(380, 335, 7048, '[\"39\",\"13\",\"710\",\"716\"]', 20250516, 620, NULL, 4, 'total test: 4, total test amount: 620, total received: , received by: Ashraful Islam Saymon', '2025-05-16 01:03:38', '2025-05-16 01:03:38'),
(381, 335, 7054, '[\"434\",\"13\",\"722\",\"98\",\"96\",\"39\",\"710\",\"716\"]', 20250516, 2400, 2400, 8, 'total test: 8, total test amount: 2400, total received: 2400, received by: Ashraful Islam Saymon', '2025-05-16 04:11:36', '2025-05-16 04:11:36'),
(382, 335, 7055, '[\"71\",\"46\",\"710\",\"716\"]', 20250516, 1200, 1000, 4, 'total test: 4, total test amount: 1200, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-16 06:04:55', '2025-05-16 06:04:55'),
(383, 1, 7055, '[\"71\",\"46\",\"710\",\"716\"]', 20250516, 1200, 1000, 4, 'total test: 4, total test amount: 1200, total received: 1000, received by: Dialab Pro', '2025-05-16 06:42:04', '2025-05-16 06:42:04'),
(384, 335, 7057, '[\"41\"]', 20250517, 1000, 1000, 1, 'total test: 1, total test amount: 1000, total received: 1000, received by: Ashraful Islam Saymon', '2025-05-16 23:09:51', '2025-05-16 23:09:51'),
(385, 335, 7028, '[\"42\"]', 20250517, 840, NULL, 1, 'total test: 1, total test amount: 840, total received: , received by: Ashraful Islam Saymon', '2025-05-17 00:09:09', '2025-05-17 00:09:09'),
(386, 335, 7028, '[\"62\"]', 20250517, 150, NULL, 1, 'total test: 1, total test amount: 150, total received: , received by: Ashraful Islam Saymon', '2025-05-17 01:20:51', '2025-05-17 01:20:51'),
(387, 335, 7058, '[\"434\",\"104\",\"105\",\"13\",\"30\",\"42\",\"710\",\"713\",\"716\"]', 20250517, 4830, NULL, 9, 'total test: 9, total test amount: 4830, total received: , received by: Ashraful Islam Saymon', '2025-05-17 05:48:02', '2025-05-17 05:48:02'),
(388, 1, 7058, '[\"434\",\"104\",\"105\",\"13\",\"30\",\"710\",\"713\",\"716\"]', 20250517, 3430, 0, 8, 'total test: 8, total test amount: 3430, total received: 0, received by: Dialab Pro', '2025-05-17 07:24:49', '2025-05-17 07:24:49'),
(389, 335, 7059, '[\"434\",\"116\",\"42\"]', 20250518, 1500, 1500, 3, 'total test: 3, total test amount: 1500, total received: 1500, received by: Ashraful Islam Saymon', '2025-05-17 23:03:20', '2025-05-17 23:03:20'),
(390, 1, 7060, '[\"2\",\"3\",\"709\",\"710\"]', 20250518, 400, 200, 4, 'total test: 4, total test amount: 400, total received: 200, received by: Dialab Pro', '2025-05-18 03:59:46', '2025-05-18 03:59:46'),
(391, 1, 7061, '[\"2\",\"709\",\"710\"]', 20250518, 220, 220, 3, 'total test: 3, total test amount: 220, total received: 220, received by: Dialab Pro', '2025-05-18 04:02:28', '2025-05-18 04:02:28');

-- --------------------------------------------------------

--
-- Table structure for table `usg_settings`
--

CREATE TABLE `usg_settings` (
  `id` int UNSIGNED NOT NULL,
  `doctor_id` int NOT NULL,
  `test_id` int NOT NULL,
  `amount` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usg_settings`
--

INSERT INTO `usg_settings` (`id`, `doctor_id`, `test_id`, `amount`, `created_at`, `updated_at`) VALUES
(2, 140, 42, 100.00, '2021-08-21 15:39:19', '2021-08-21 16:47:58'),
(3, 140, 41, 200.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(4, 140, 43, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(5, 140, 44, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(6, 140, 45, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(7, 140, 46, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(8, 140, 47, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(9, 140, 172, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(10, 140, 182, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(11, 140, 188, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(12, 140, 198, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58'),
(13, 140, 277, 100.00, '2021-08-21 16:47:58', '2021-08-21 16:47:58');

-- --------------------------------------------------------

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` int UNSIGNED NOT NULL,
  `patient_id` int NOT NULL,
  `fee` int NOT NULL,
  `discount` float DEFAULT NULL,
  `admin_id` int NOT NULL,
  `doctor_id` int NOT NULL,
  `type` int NOT NULL,
  `doctor_type` int DEFAULT NULL,
  `serial` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abouts`
--
ALTER TABLE `abouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `about_menus`
--
ALTER TABLE `about_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin_permissions`
--
ALTER TABLE `admin_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `advertisements`
--
ALTER TABLE `advertisements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `advices`
--
ALTER TABLE `advices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `backups`
--
ALTER TABLE `backups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bills`
--
ALTER TABLE `bills`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `catagories`
--
ALTER TABLE `catagories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `discounts`
--
ALTER TABLE `discounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `doctor_breaks`
--
ALTER TABLE `doctor_breaks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `doctor_commissions`
--
ALTER TABLE `doctor_commissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `doctor_youtube_links`
--
ALTER TABLE `doctor_youtube_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `doctor_id` (`doctor_id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hospital_services`
--
ALTER TABLE `hospital_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ins_infos`
--
ALTER TABLE `ins_infos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investor_expenses`
--
ALTER TABLE `investor_expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investor_expense_histories`
--
ALTER TABLE `investor_expense_histories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investor_funds`
--
ALTER TABLE `investor_funds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investor_histories`
--
ALTER TABLE `investor_histories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lab_report_headers`
--
ALTER TABLE `lab_report_headers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `licence_keys`
--
ALTER TABLE `licence_keys`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_permissions`
--
ALTER TABLE `menu_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patient_payments`
--
ALTER TABLE `patient_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patient_tests`
--
ALTER TABLE `patient_tests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patient_test_values`
--
ALTER TABLE `patient_test_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `profit_distributes`
--
ALTER TABLE `profit_distributes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `queue_notices`
--
ALTER TABLE `queue_notices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `queue_notices_doctor_id_foreign` (`doctor_id`);

--
-- Indexes for table `return_serials`
--
ALTER TABLE `return_serials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `serials`
--
ALTER TABLE `serials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `serial_counts`
--
ALTER TABLE `serial_counts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `share_holders`
--
ALTER TABLE `share_holders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `store_serials`
--
ALTER TABLE `store_serials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tests`
--
ALTER TABLE `tests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test_addons_configs`
--
ALTER TABLE `test_addons_configs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test_params`
--
ALTER TABLE `test_params`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test_reagent_configs`
--
ALTER TABLE `test_reagent_configs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `test_values`
--
ALTER TABLE `test_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `treatments`
--
ALTER TABLE `treatments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_logs`
--
ALTER TABLE `user_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `usg_settings`
--
ALTER TABLE `usg_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visits`
--
ALTER TABLE `visits`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abouts`
--
ALTER TABLE `abouts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `about_menus`
--
ALTER TABLE `about_menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `admin_permissions`
--
ALTER TABLE `admin_permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7274;

--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `advertisements`
--
ALTER TABLE `advertisements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `advices`
--
ALTER TABLE `advices`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `backups`
--
ALTER TABLE `backups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bills`
--
ALTER TABLE `bills`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- AUTO_INCREMENT for table `catagories`
--
ALTER TABLE `catagories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `discounts`
--
ALTER TABLE `discounts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `doctor_breaks`
--
ALTER TABLE `doctor_breaks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `doctor_commissions`
--
ALTER TABLE `doctor_commissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `doctor_youtube_links`
--
ALTER TABLE `doctor_youtube_links`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `hospital_services`
--
ALTER TABLE `hospital_services`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ins_infos`
--
ALTER TABLE `ins_infos`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `investor_expenses`
--
ALTER TABLE `investor_expenses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `investor_expense_histories`
--
ALTER TABLE `investor_expense_histories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `investor_funds`
--
ALTER TABLE `investor_funds`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `investor_histories`
--
ALTER TABLE `investor_histories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;

--
-- AUTO_INCREMENT for table `lab_report_headers`
--
ALTER TABLE `lab_report_headers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `licence_keys`
--
ALTER TABLE `licence_keys`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `menu_permissions`
--
ALTER TABLE `menu_permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1356;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=328;

--
-- AUTO_INCREMENT for table `patient_payments`
--
ALTER TABLE `patient_payments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

--
-- AUTO_INCREMENT for table `patient_tests`
--
ALTER TABLE `patient_tests`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=218;

--
-- AUTO_INCREMENT for table `patient_test_values`
--
ALTER TABLE `patient_test_values`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=576;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=174;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `profit_distributes`
--
ALTER TABLE `profit_distributes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `queue_notices`
--
ALTER TABLE `queue_notices`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `return_serials`
--
ALTER TABLE `return_serials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `serials`
--
ALTER TABLE `serials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `serial_counts`
--
ALTER TABLE `serial_counts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `share_holders`
--
ALTER TABLE `share_holders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `store_serials`
--
ALTER TABLE `store_serials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tests`
--
ALTER TABLE `tests`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=751;

--
-- AUTO_INCREMENT for table `test_addons_configs`
--
ALTER TABLE `test_addons_configs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=308;

--
-- AUTO_INCREMENT for table `test_params`
--
ALTER TABLE `test_params`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `test_reagent_configs`
--
ALTER TABLE `test_reagent_configs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;

--
-- AUTO_INCREMENT for table `test_values`
--
ALTER TABLE `test_values`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=870;

--
-- AUTO_INCREMENT for table `treatments`
--
ALTER TABLE `treatments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `user_logs`
--
ALTER TABLE `user_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=392;

--
-- AUTO_INCREMENT for table `usg_settings`
--
ALTER TABLE `usg_settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `visits`
--
ALTER TABLE `visits`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `doctor_youtube_links`
--
ALTER TABLE `doctor_youtube_links`
  ADD CONSTRAINT `doctor_youtube_links_ibfk_1` FOREIGN KEY (`doctor_id`) REFERENCES `patients` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `queue_notices`
--
ALTER TABLE `queue_notices`
  ADD CONSTRAINT `queue_notices_doctor_id_foreign` FOREIGN KEY (`doctor_id`) REFERENCES `patients` (`id`) ON DELETE CASCADE;
COMMIT;

