$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; }