$part1Table = "<table class='table table-condensed table-bordered'><tr class='dark'><td colspan='8'> <b> REPORT FORM <b> </td></tr><tr><td> Report No. </td><td> Report Type </td><td> Case Type </td><td> Reference Number </td><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td colspan='8'> <b> PATIENT DEMOGRAPHIC </b> </td></tr><tr><td> Age </td><td> Age Group </td><td> Sex </td><td> Pregnancy Status </td><td> Ethnic </td><td> Allergy Status </td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td colspan='8'> <b> Medical History </b> </td></tr><tr><td colspan='8'></td></tr></table>";
}
// $part1Table .= "</table>";
}
$sqlPart2 = "SELECT adrDetailID, AdrTerminology, socMeddra, Adr_onsetDate, Adr_rctFirstTime, Adr_rctFirstTimeUnit, Adr_outcome, seriousness, seriousnessCrit\n\t\t\t\t\t\t\t\t\tFROM adrdetail WHERE adrFormID = '{$fID}'";
$resPart2 = mysqli_query($con, $sqlPart2);
if ($resPart2) {
$part2Table = "<table border='1' class='table table-condensed table-bordered'><tr class='dark'><td colspan='8'> <b> ADVERSE DRUG REACTION </b> </td></tr><tr><td>ADR Terminology</td><td>System Organ Class</td><td>Date of Onset</td><td>Onset of Reaction / Time Interval Unit</td><td>Outcome of Reaction</td><td>Seriousness</td><td>Seriousness Criteria</td><td></td></tr>";
if (mysqli_num_rows($resPart2) > 0) {
while ($rowPart2 = mysqli_fetch_array($resPart2)) {
$AdrTerminology = $rowPart2['AdrTerminology'];
$socMeddra = $rowPart2['socMeddra'];
$Adr_onsetDate = dateChecker($rowPart2['Adr_onsetDate']);
$Adr_rctFirstTime = $rowPart2['Adr_rctFirstTime'];
$Adr_rctFirstTimeUnit = getAgeUnitByValue($con, $rowPart2['Adr_rctFirstTimeUnit']);
$Adr_outcome = getOutcomeByValue($con, $rowPart2['Adr_outcome']);
$seriousness = $rowPart2['seriousness'];
if ($seriousness == 1) {
$seriousness = "Yes";
} else {
if ($seriousness == 2) {
$seriousness = "No";
}
}
$seriousnessCrit = getSeriousnessCritByValue($con, $rowPart2['seriousnessCrit']);
$AdrTerminology = $rowPart2['AdrTerminology'];
$part2Table .= "<tr> <td>{$AdrTerminology}</td> <td>{$socMeddra}</td> <td>{$Adr_onsetDate}</td> <td>{$Adr_rctFirstTime} {$Adr_rctFirstTimeUnit}</td> <td>{$Adr_outcome}</td> <td>{$seriousness}</td> <td>{$seriousnessCrit}</td> <td></td> </tr>";
}
} else {
$part2Table .= "<tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr>";
}
function getReactionStrByFormID($con, $formID)
{
$sql = "SELECT DISTINCT adrDetailID, AdrTerminology, socMeddra, Adr_onsetDate, Adr_rctFirstTime, Adr_rctFirstTimeUnit, Adr_outcome, seriousness, seriousnessCrit\n\tFROM adrdetail WHERE adrFormID = '{$formID}'";
$res = mysqli_query($con, $sql);
$adrStr = "<table class='table table-condensed table-bordered table-hover'>";
if ($res) {
if (mysqli_num_rows($res) > 0) {
while ($row = mysqli_fetch_array($res)) {
$AdrTerminology = $row['AdrTerminology'];
$socMeddra = $row['socMeddra'];
$Adr_onsetDate = dateChecker($row['Adr_onsetDate']);
$Adr_rctFirstTime = $row['Adr_rctFirstTime'];
$Adr_rctFirstTimeUnit = getAgeUnitByValue($con, $row['Adr_rctFirstTimeUnit']);
$Adr_outcome = getOutcomeByValue($con, $row['Adr_outcome']);
$seriousness = $row['seriousness'];
if ($seriousness == 1) {
$seriousness = "Yes";
} else {
if ($seriousness == 2) {
$seriousness = "No";
} else {
$seriousness = "";
}
}
$seriousnessCrit = getSeriousnessCritByValue($con, $row['seriousnessCrit']);
$adrStr .= "<tr>\n\t\t\t\t<td>\n\t\t\t\t\tADR Terminology: {$AdrTerminology} <br/>\n\t\t\t\t\tSystem Organ Class: {$socMeddra} <br/>\n\t\t\t\t\tDate of Onset: {$Adr_onsetDate} <br/>\n\t\t\t\t\tOnset of Reaction / Time Interval Unit: {$Adr_rctFirstTime} {$Adr_rctFirstTimeUnit} <br/>\n\t\t\t\t\tOutcome of Reaction: {$Adr_outcome} <br/>\n\t\t\t\t\tSeriousness: {$seriousness} <br/>\n\t\t\t\t\tSeriousness Criteria: {$seriousnessCrit} <br/>\n\t\t\t\t</td>\n\t\t\t</tr>";
}
$adrStr .= "</table>";
} else {
$adrStr .= "No Drug Found";
}
} else {
$adrStr .= "E";
}
return $adrStr;
}
