while ($row = ibase_fetch_row($res)) { $unit = $row[2]; $charlimits = str_replace('%', '\\%', $row[3]); $charlimits = str_replace('^', '\\^{}', $charlimits); $ress = $row[1]; if ($row[4] == "O") { $ress = "\\textbf{" . $row[1] . "}"; } $results .= "~ \\footnotesize " . $row[0] . " & \\footnotesize " . $ress . " & \\footnotesize " . $unit . " \\\\ \n"; $results .= "\\hline" . "\n"; } ibase_free_result($res); } } } $user = getUserEnterResults($ordersid, $dbh); $appruser = getApprUser($ordersid, $dbh); $comments = ""; $restm = "select distinct f.comments from foldercomments f inner join orders o on o.folderno = f.folderno where o.id in(" . $ordersid . ") and f.flag = 'Y' order by f.id"; $res = ibase_query($dbh, $restm); while ($row = ibase_fetch_row($res)) { $comments .= "\\small \\quad " . $row[0] . "\n\n"; } ibase_free_result($res); $biomat = find_biomat($ordersid, $dbh); $head = "\\SetWatermarkText{" . $watermark . "}\n"; $head .= "\\vspace{-10px} \\flushleft \\normalsize Биоматериал: " . $biomat . "\n\n\\vspace{3px}"; $head .= "\n\\begin{longtable}[h]{|m{230px}|>{\\centering\\arraybackslash}p{140px}|m{90px}|}\n\\hline\nИсследование & Результат & Единицы \\newline измерения \\\\\n\\hline"; $apprdate = find_apprdate($ordersid, $dbh); $comments = str_replace('%', '\\%', $comments); $end = "\\end{longtable}\n\\vspace{-15px}\n\\flushleft Комментарии:" . $comments . "\n\\vspace{-4px}\n\\flushleft Исследования проводил: " . $user . " \n\\vspace{-4px}\n\\flushleft Выпускающий врач: " . $appruser . " \n\\newline\n\\flushright Дата выдачи: " . $apprdate;
$unit = $row[2]; //$unit = str_replace('%','\\%',$row[2]); //$unit = str_replace('^','\\^{}',$unit); $charlimits = str_replace('%', '\\%', $row[3]); $charlimits = str_replace('^', '\\^{}', $charlimits); $ress = $row[1]; if ($row[4] == "O") { $ress = "\\textbf{" . $row[1] . "}"; } $results .= "~ \\footnotesize " . $row[0] . " & \\footnotesize " . $ress . " & \\footnotesize " . $unit . " & \\footnotesize " . $charlimits . " \\\\ \n"; $results .= "\\hline" . "\n"; } ibase_free_result($res); } } $user = getUserEnterResults($orderis, $dbh); $appruser = getApprUser($ordersid, $dbh); $comments = ""; $restm = "select distinct f.comments from foldercomments f inner join orders o on o.folderno = f.folderno where o.id in(" . $ordersid . ") and f.flag = 'Y' order by f.id"; $res = ibase_query($dbh, $restm); while ($row = ibase_fetch_row($res)) { $comments .= "\\small \\quad " . $row[0] . "\n\n"; } ibase_free_result($res); $biomat = find_biomat($ordersid, $dbh); $panelname = find_panel($ordersid, $dbh); $head = "\\SetWatermarkText{" . $watermark . "}\n"; $head .= "\\vspace{-10px} \\flushleft \\normalsize Биоматериал: " . $biomat . "\n\n\\vspace{3px}"; $head .= "\n\n\\vspace{1px}"; $head .= "\\begin{center} "; $head .= "\\textbf{" . $panelname . "}\\end{center} \n\n\\vspace{-5px}";