if (mysqli_num_rows($res) > 0) { $generateButton = "<input type='submit' name='export' value='Generate Report' class='btn btn-success'/>"; $c = 1; while ($row = mysqli_fetch_array($res)) { $formID = $row['adrFormID']; $drugStr = getDrugStrByFormID($con, $formID); $reacStr = getReactionStrByFormID($con, $formID); $adrNo = $row['Adrno']; if ($adrNo == "" || $adrNo == NULL || empty($adrNo)) { $adrNo = $formID; } $age = $row['age']; if ($age == "NULL") { $age = ""; } $ageUnit = getAgeUnitByValue($con, $row['age_unit']); $sex = $row['sex']; if ($sex == 1) { $sex = "Male"; } else { if ($sex == 2) { $sex = "Female"; } else { if ($sex == 3) { $sex = "Unknown"; } } } $ethnic = getEthnicByValue($con, $row['ethnic']); $desig = $row['desig']; $org = $row['reporter_org'];
} else { $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>";
if ($adetailRes) { if (mysqli_num_rows($adetailRes) > 0) { $adetailRows = mysqli_fetch_array($adetailRes); $Adr_onsetDate = $adetailRows['Adr_onsetDate']; $Adr_endDate = $adetailRows['Adr_endDate']; $Adr_Dur = $adetailRows['Adr_durUnit']; $Adr_outcome = $adetailRows['Adr_outcome']; $seriousness = getYesNo($adetailRows['seriousness']); $seriousnessCrit = getSeriousnessCritByValue($con, $adetailRows['seriousnessCrit']); $Adr_dateofDeath = $adetailRows['Adr_dateofDeath']; $Adr_causeofDeath = $adetailRows['Adr_causeofDeath']; $Adr_autopsyyesno = getYesNo($adetailRows['Adr_autopsyyesno']); $Adr_detDeath = $adetailRows['Adr_detDeath']; $Adr_treat = $adetailRows['Adr_treat']; $Adr_rctFirstTime = $adetailRows['Adr_rctFirstTime']; $Adr_rctFirstTimeUnit = getAgeUnitByValue($con, $adetailRows['Adr_rctFirstTimeUnit']); } } // DRUG TABLE $drugTable = '<table border="1" cellpadding="1"> <tr> <th>Chracterisation</th> <th>Product</th> <th>MAL No.</th> <th>Active Ingredient</th> <th>Dose / Dose Unit</th> <th>Dose Frequency</th> <th>Indication</th> <th>Therapy Start Date</th> <th>Therapy Stop Date</th> <th>Relatedness</th> </tr>'; $adrugSql = "SELECT DISTINCT adrFormID, product_name, dosage, dosageUnit, DATE_FORMAT(therapy_start, '%d/%m/%Y') AS therapy_start, DATE_FORMAT(therapy_stop, '%d/%m/%Y') AS therapy_stop, \n\t\t\tsuspected, indication, unit, freq, route, generic, icdcode, dcount, drug_cat, manf, pharm_gr, drug_gr, \n\t\t\tduration, atccode, product_ref, sus_state, req_holder, MALnum, actvIngredient, Pharmaceutical, \n\t\t\tPharmacological, doseInterval, doseIntervalUnit, doseIntervalUnitOtr, cumDoseDay, cumDoseDayUnit, \n\t\t\tdrugAction, relatedness, actionTaken, subsided, reappear, rptrCmmt, conserf_reason, conserf_medType\n\t\t\tFROM adr_druglist WHERE adrFormID = '{$formID}'"; $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']);
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; }