$reappear = "Yes"; } else { if ($reappear == 2) { $reappear = "No"; } else { if ($reappear == 3) { $reappear = "Unknown"; } else { if ($reappear == 4) { $reappear = "Not Applicable"; } } } } $AdrTerminology = $rowPart4['AdrTerminology']; $relatedness = getRelatednessByValue($con, $rowPart4['relatedness']); $part4Table .= "<tr> <td>{$suspected}</td> <td>{$actvIngredient}</td> <td>{$actionTaken}</td> <td> {$subsided} </td> <td> {$reappear} </td> <td>{$AdrTerminology}</td> <td>{$relatedness}</td> <td> </td> </tr>"; } } else { $part4Table .= "<tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr>"; } $part4Table .= "</table>"; } $sqlPart5 = "SELECT adrDataIDAI, Source, reporter_state, reporter_org, dateRcv\n\t\t\t\t\t\t\t\t\tFROM adrdata WHERE adrFormID = '{$fID}'"; $resPart5 = mysqli_query($con, $sqlPart5); if ($resPart5) { $part5Table = "<table border='1' class='table table-condensed table-bordered'><tr class='dark'><td colspan='8'> <b> REPORTER INFORMATION </b> </td></tr><tr><td> Qualification </td><td> Primary Source Qualification </td><td> State </td><td> Instituition </td><td> Date of Report </td><td> </td><td> </td><td> </td></tr>"; if (mysqli_num_rows($resPart5) > 0) { $rowPart5 = mysqli_fetch_array($resPart5); $Source = getPrimSourceByValue($con, $rowPart5['Source']); $reporter_state = $rowPart5['reporter_state'];
$adrugRes = mysqli_query($con, $adrugSql); if ($adrugRes) { if (mysqli_num_rows($adrugRes) > 0) { while ($adrugRows = mysqli_fetch_assoc($adrugRes)) { $suspected = getCharacterisation($adrugRows['suspected']); $product_name = $adrugRows['product_name']; $MALnum = $adrugRows['MALnum']; $actvIngredient = $adrugRows['actvIngredient']; $dosage = $adrugRows['dosage']; $dosageUnit = getDoseUnitByValue($con, $adrugRows['dosageUnit']); $doseInterval = $adrugRows['doseInterval']; $doseIntervalUnit = getDoseUnitByValue($con, $adrugRows['doseIntervalUnit']); $indication = $adrugRows['indication']; $therapy_start = $adrugRows['therapy_start']; $therapy_stop = $adrugRows['therapy_stop']; $relatedness = getRelatednessByValue($con, $adrugRows['relatedness']); $drugTable .= '<tr> <td> ' . $suspected . ' </td> <td> ' . $product_name . ' </td> <td> ' . $MALnum . ' </td> <td> ' . $actvIngredient . ' </td> <td> ' . $dosage . ' ' . $dosageUnit . ' </td> <td> ' . $doseInterval . ' ' . $doseIntervalUnit . ' </td> <td> ' . $indication . ' </td> <td> ' . $therapy_start . ' </td> <td> ' . $therapy_stop . ' </td> <td> ' . $relatedness . ' </td> </tr>'; } } }
<!-- Content Header --> <div class="content-header"> <h2><b class="text-primary"> ADR </b> MADRAC List </h2> </div> <div class="col-md-12"> <div class="panel"> <div class="panel-body"> <div class="tab-content pn br-n admin-form"> <?php if (isset($_POST)) { $relatedness = $_POST['relatedness']; $relatednessDesc = getRelatednessByValue($con, $relatedness); $madracno = trim($_POST['madracno']); $Pharmacological = $_POST['Pharmacological']; $sumTable = "<table class='table table-bordered'>\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<td width='40%'> Relatedness Drug Reaction: </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td width='60%'> {$relatedness} - {$relatednessDesc} </td>\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<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> MADRAC No. : </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$madracno} </td>\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<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> Pharmacological Group: </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Pharmacological} </td>\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</table><hr/>"; echo $sumTable; // echo "$relatedness, $madracno, $Pharmacological"; $sql1 = "SELECT DISTINCT adrug.actvIngredient, adrug.product_name\n\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\tWHERE adata.adrFormID = adrug.adrFormID\n\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\tAND adata.`status` = 'MM'\n\t\t\t\t\t\t\t\t\t\t\tAND (adrug.actvIngredient != '' OR adrug.actvIngredient IS NULL)\n\t\t\t\t\t\t\t\t\t\t\tAND (adrug.product_name != '' OR adrug.product_name IS NULL)\n\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\tAND adata.Madracno = '{$madracno}'\n\t\t\t\t\t\t\t\t\t\t\tAND adrug.Pharmacological = '{$Pharmacological}'"; $res1 = mysqli_query($con, $sql1); if ($res1) { if (mysqli_num_rows($res1) > 0) { $c1 = 1; $resTable = "<table class='table table-bordered' border='1'>\n\t\t\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\t\t<th> No. </th>\n\t\t\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\t\t<th> Product Name </th>\n\t\t\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\t\t<th width='10%'> Report No. </th>\n\t\t\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\t\t<th width='8%'> Onset </th>\n\t\t\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\t\t<th> Action Taken </th>\n\t\t\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\t\t<th> Rechallange </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>"; while ($row1 = mysqli_fetch_array($res1)) { $actvIngredient = $row1['actvIngredient']; $product_name = $row1['product_name']; $sql2 = "SELECT DISTINCT adrug.route, adata.Adrno, adata.age, adata.age_unit, adetail.Adr_rctFirstTime, adetail.Adr_rctFirstTimeUnit, adetail.AdrTerminology, adrug.drugAction, adrug.subsided, adrug.reappear\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 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}'";