while ($rowPart3 = mysqli_fetch_array($resPart3)) {
$suspected = $rowPart3['suspected'];
if ($suspected == 1) {
$suspected = "Suspected";
} else {
if ($suspected == 2) {
$suspected = "Interaction";
} else {
if ($suspected == 3) {
$suspected = "Concomitant";
}
}
}
$actvIngredient = $rowPart3['actvIngredient'];
$product_name = $rowPart3['product_name'];
$route = getRouteByValue($con, $rowPart3['route']);
$dosage = $rowPart3['dosage'];
$dosageUnit = getDoseUnitByValue($con, $rowPart3['dosageUnit']);
$doseInterval = $rowPart3['doseInterval'];
$indication = $rowPart3['indication'];
$therapy_start = dateChecker($rowPart3['therapy_start']);
$therapy_stop = dateChecker($rowPart3['therapy_stop']);
$part3Table .= "<tr> <td>{$suspected}</td> <td>{$actvIngredient}</td> <td>{$product_name}</td> <td> {$route} </td> <td>{$dosage} {$dosageUnit}</td> <td>{$doseInterval}</td> <td>{$indication}</td> <td>{$therapy_start} - {$therapy_stop}</td> </tr>";
}
} else {
$part3Table .= "<tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr>";
}
$part3Table .= "</table>";
}
$sqlPart4 = "SELECT DISTINCT adrug.suspected, adrug.actvIngredient, adrug.actionTaken, adrug.subsided, adrug.reappear, adetail.AdrTerminology, adrug.relatedness\n\t\t\t\t\t\t\t\t\tFROM adrdata adata, adrdetail adetail, adr_druglist adrug\n\t\t\t\t\t\t\t\t\tWHERE adata.adrFormID = adetail.adrFormID\n\t\t\t\t\t\t\t\t\tAND adata.adrFormID = adrug.adrFormID\n\t\t\t\t\t\t\t\t\tAND adrug.adrdetailID = adetail.adrDetailID\n\t\t\t\t\t\t\t\t\tAND adata.adrFormID = '{$fID}'";
$resPart4 = mysqli_query($con, $sqlPart4);
if ($res1) {
if (mysqli_num_rows($res1) > 0) {
$c1 = 1;
$resTable = "\n\t\t\t\t\t\t\t\t\t\t\t\t\t<table class='table table-bordered table-condensed' border='1'>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> No. </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Active Ingredient </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Product Name </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Route </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='10%'> Report No. </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='8%'> Age </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Allergy Status </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='8%'> Onset </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Reaction Terminology </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Action Taken </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Dechallenge </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Rechallenge </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Outcome </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Relevant Medical History </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Relevant Lab Data </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Report Comments </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>";
while ($row1 = mysqli_fetch_array($res1)) {
$actvIngredient = trim($row1['actvIngredient']);
$product_name = trim($row1['product_name']);
// echo "<br/> #$actvIngredient# - #$product_name# <br/>";
$sql2 = "SELECT DISTINCT adrug.route, adata.Adrno, adata.age, adata.age_unit, adata.allergyStat, adetail.Adr_rctFirstTime, adetail.Adr_rctFirstTimeUnit, adetail.AdrTerminology, adrug.drugAction, adrug.subsided, adrug.reappear, adetail.Adr_outcome, adata.history, adata.lab_data, adata.report_comment\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM adrdata adata, adr_druglist adrug, adrdetail adetail\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE adata.adrFormID = adrug.adrFormID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.adrFormID = adetail.adrFormID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.adrdetailID = adetail.adrDetailID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND (adrug.suspected = '1' OR adrug.suspected = '2')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.`status` = 'MM'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.relatedness = '{$relatedness}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.Madracno = '{$madracno}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.Pharmacological = '{$Pharmacological}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.actvIngredient = '{$actvIngredient}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.product_name = '{$product_name}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY adata.Adrno, adetail.AdrTerminology";
$res2 = mysqli_query($con, $sql2);
if ($res2) {
$numrow_res2 = mysqli_num_rows($res2);
if (mysqli_num_rows($res2) > 0) {
$cs = true;
while ($row2 = mysqli_fetch_array($res2)) {
$route = getRouteByValue($con, $row2['route']);
$Adrno = $row2['Adrno'];
// echo "<br/>$Adrno";
$age = $row2['age'];
if ($age == "NULL") {
$age = "";
}
$age_unit = getAgeUnitByValue($con, $row2['age_unit']);
$allergyStat = $row2['allergyStat'];
if ($allergyStat == 1) {
$allergyStat = "Yes";
} else {
if ($allergyStat == 2) {
$allergyStat = "No";
} else {
if ($allergyStat == 3) {
