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