<?php
/******************************************************************************/
/* MODUL: stats/print.php4 */
/* */
/* DATUM: 27.03.2006, Version 0.1 */
/* BESCHR.: Druckfreundliche Ausgabe von ETBs und Patientenliste */
/* */
/* AUTOR: Marcus Groh */
/* LIZENZ: GPL v2 vom Juni 1991 */
/* */
/* AENDERUNGEN: 01.07.2004 -initiale Version */
/* 27.03.2006 v 0.1, -Versionskennzeichnung eingefuehrt */
/* -Code unter GPL v2 gestellt */
/* -Tabellenname dynamisiert */
/* */
/******************************************************************************/
$allowed_groups=array("elw");
include ('../_include/printer.php4');
// Define in this script the requested selections
include ('./get_stats.php4');
?>
<br>
<center>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<th colspan="3">Einsatzdaten</th>
</tr>
<tr>
<td> Einsatzbeschreibung:</td>
<td width="30"> </td>
<td><? echo $einsatz_name ; ?> </td>
</tr>
<tr>
<td> Einsatzbeginn:</td>
<td width="30"> </td>
<td><? echo $result_etb_first_date . ' - ' . $result_etb_first_time; ?></td>
</tr>
<tr>
<td> Einsatzende:</td>
<td width="30"> </td>
<td><? echo $result_etb_last_date . ' - ' . $result_etb_last_time; ?></td>
</tr>
<tr>
<td> Einsatzdauer:</td>
<td width="30"> </td>
<td><? echo $result_etb_diff_h . ':' . $result_etb_diff_m . ':' . $result_etb_diff_s ; ?> h</td>
</tr>
<tr>
<td> Anzahl disponierte Abschnitte:</td>
<td width="30"> </td>
<td><? echo $result_max_abs_eintr ; ?></td>
</tr>
<tr>
<td> Anzahl disponierte Fahrzeuge:</td>
<td width="30"> </td>
<td><? echo $result_max_fzg_eintr ; ?></td>
</tr>
<tr>
<td> Anzahl disponierte Teams:</td>
<td width="30"> </td>
<td><? echo $result_max_team_eintr ; ?></td>
</tr>
<tr>
<td> Anzahl Aufträge:</td>
<td width="30"> </td>
<td><? echo $max_auftr_eintr ; ?></td>
</tr>
<tr>
<td> Anzahl erfasster Patienten:</td>
<td width="30"> </td>
<td><? echo $result_max_pat_eintr ; ?></td>
</tr>
<tr>
<td> Anzahl Transporte:</td>
<td width="30"> </td>
<td><? echo $result_max_pat_trans ; ?></td>
</tr>
</table>
<br>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<th colspan="3">webETB Statistiken</th>
</tr>
<tr>
<td> Anzahl Tagebucheinträge:</td>
<td width="30"> </td>
<td><? echo $max_etb_eintr ; ?></td>
</tr>
<tr>
<td colspan="3" align="left"><p id="sw08_s"> Ermittelt anhand von 15 min. Rasterungen:</p></td>
</tr>
<tr>
<td> Einträge pro Minute (MIN):</td>
<td width="30"> </td>
<td valign="top"><? echo $actions_per_minute_min ; ?> </td>
</tr>
<tr>
<td> Einträge pro Minute (MAX):</td>
<td width="30"> </td>
<td valign="top"><? echo $actions_per_minute_max ; ?> </td>
</tr>
<tr>
<td> Einträge pro Minute (MEAN):</td>
<td width="30"> </td>
<td valign="top"><? echo $actions_per_minute_mean ; ?> </td>
</tr>
</table>
<br><br>
<center>
<table border="0" cellpadding="0" cellspacing="0" width="950">
<tr>
<th colspan="9">Einsatztagebuch - Verlauf</th>
</tr>
<tr>
<td width="30" align="middle"><p id="GR07">Lfd-Nr.</p></td>
<td width="70" align="middle"><p id="GR07">Datum</p></td>
<td width="60" align="middle"><p id="GR07">Zeit</p></td>
<td width="80" align="middle"><p id="GR07">Von</p></td>
<td width="80" align="middle"><p id="GR07">An</p></td>
<td width="350" align="left"><p id="GR07">Text</p></td>
<td width="100" align="left"><p id="GR07">Bemerkung</p></td>
<td width="100" align="middle"><p id="GR07">Patient</p></td>
<td width="30" align="middle"><p id="GR07">Bearbeiter</p></td>
</tr>
<tr>
<td colspan="9" height="1" width="950" style="background-color: #000000;"><img src="../_img/spacer.gif" height="1" width="950" border="0"></td>
</tr>
<?
$select_etb_log="select * from $T_etb where eid=$eid order by lfdnr";
$result_etb_log=@mysql_db_query($database["database"],$select_etb_log,$db);
while ( $row=mysql_fetch_array($result_etb_log) )
{
// sort fields
$lfdnr=$row['lfdnr'];
$von_kid=$row['von_kid'];
$an_kid=$row['an_kid'];
$von_txt=$row['von_txt'];
$an_txt=$row['an_txt'];
list ($Y, $M, $D) = split ('[/.-]', $row['datum']);
$datum="$D-$M-$Y";
$zeit=$row['zeit'];
$text=$row['text'];
$bemerkung=$row['bemerkung'];
$bezug=$row['bezug'];
$db_uid=$row['uid'];
// set readable text for field "VON"
if ( $von_kid == "0" )
{
$von=$von_txt;
}
else
{
$select_von="select rufname from $T_kraefte where eid=$eid and kid=$von_kid";
$result_von=@mysql_db_query($database["database"],$select_von,$db);
while ( $row=mysql_fetch_array($result_von) )
{
$von=$row['rufname'];
}
}
// set readable text for field "AN"
if ( $an_kid == "0" )
{
$an=$an_txt;
}
else
{
$select_an="select rufname from $T_kraefte where eid=$eid and kid=$an_kid";
$result_an=@mysql_db_query($database["database"],$select_an,$db);
while ( $row=mysql_fetch_array($result_an) )
{
$an=$row['rufname'];
}
}
// set readable text for field "BEARBEITER"
$select_user="select u_name from $T_user where uid=$db_uid";
$result_user=@mysql_db_query($database["database"],$select_user,$db);
while ( $row=mysql_fetch_array($result_user) )
{
$user=$row['u_name'];
}
// set readable text for field "BEZUG"
$select_bezug="select pat_nr from $T_patient where eid=$eid and pid=$bezug";
$result_bezug=@mysql_db_query($database["database"],$select_bezug,$db);
$count_bezug=mysql_num_rows($result_bezug);
if ( $count_bezug <= 0 )
{
$aufgabe="";
}
else
{
while ( $row=mysql_fetch_array($result_bezug) )
{
$aufgabe=$row['pat_nr'];
}
}
// print values
?>
<tr>
<td width="30" valign="top" align="middle"><p id="sw10_s"><? echo $lfdnr; ?></td>
<td width="70" valign="top" align="middle"><p id="sw10_s"><? echo $datum; ?></td>
<td width="60" valign="top" align="middle"><p id="sw10_s"><? echo $zeit; ?></td>
<td width="80" valign="top" align="middle"><p id="sw10_s"><? echo $von; ?></td>
<td width="80" valign="top" align="middle"><p id="sw10_s"><? echo $an; ?></td>
<td width="360" valign="top" align="left" ><p id="sw10_s"><? echo $text; ?></td>
<td width="100" valign="top" align="left" ><p id="sw10_s"><? echo $bemerkung; ?></td>
<td width="100" valign="top" align="middle"><p id="sw10_s"><? echo $aufgabe; ?></td>
<td width="30" valign="top" align="middle"><p id="sw10_s"><? echo $user; ?></td>
</tr>
<tr>
<td colspan="9" height="1" width="950" style="background-color: #999999;"><img src="../_img/spacer.gif" height="1" width="950" border="0"></td>
</tr>
<?
}
?>
</table>
<br><br>
<table border="0" cellpadding="0" cellspacing="0" width="950">
<tr>
<th colspan="9">Patientenliste</th>
</tr>
<tr>
<td width="70" align="middle"><p id="GR07">Pat-Nr.</p></td>
<td width="60" align="middle"><p id="GR07">Zeit<br>REG</p></td>
<td width="60" align="middle"><p id="GR07">Zeit<br>SAN</p></td>
<td width="200" align="left" ><p id="GR07"> Diagnose<br> Bemerkung</p></td>
<td width="150" align="left" ><p id="GR07"> Nachname<br> Vorname<br> Geb.-Datum</p></td>
<td width="150" align="left" ><p id="GR07"> Wohnort<br> Straße</p></td>
<td width="60" align="middle"><p id="GR07">Fahrzeug</p></td>
<td width="70" align="middle"><p id="GR07">Zeitpunkt<br>Abfahrt</p></td>
<td width="130" align="middle"><p id="GR07">Zielklinik<br>bzw. Verbleib</p></td>
</tr>
<tr>
<td colspan="9" height="1" width="950" style="background-color: #000000;"><img src="../_img/spacer.gif" height="1" width="950" border="0"></td>
</tr>
<?
$select_pat_list="select rlsnr, pat_nr, pat_nname, pat_vname, pat_geb, pat_ort, pat_str, fzg_name, fzg_typ, fzg_zeit, fzg_ziel, reg_time, san_diag, san_comm, san_time from $T_patient where eid=$eid and used='Y' order by pat_nr";
$result_pat_list=@mysql_db_query($database["database"],$select_pat_list,$db);
while ( $row=mysql_fetch_array($result_pat_list) )
{
// sort fields
$RLS="";
$db_rlsnr=checkval($row['rlsnr']);
if ($db_rlsnr)
{
$RLS="RLSt.-Nr.: " .$db_rlsnr;
}
$db_pat_nr=checkval($row['pat_nr']);
$db_pat_nname=checkval ($row['pat_nname']);
$db_pat_vname=checkval ($row['pat_vname']);
$db_pat_geb=checkdateval ($row['pat_geb']);
$db_pat_ort=checkval ($row['pat_ort']);
$db_pat_str=checkval ($row['pat_str']);
$db_fzg_name=checkval ($row['fzg_name']);
$FZG="";
$db_fzg_typ=checkval ($row['fzg_typ']);
if ( $db_fzg_typ &0x1 )
{
$FZG="MTW";
}
elseif ( $db_fzg_typ &0x2 )
{
$FZG="KTW";
}
elseif ( $db_fzg_typ &0x4 )
{
$FZG="RTW";
}
elseif ( $db_fzg_typ &0x8 )
{
$FZG="NAW";
}
elseif ( $db_fzg_typ &0x10 )
{
$FZG="RTH";
}
elseif ( $db_fzg_typ &0x20 )
{
$FZG="POL";
}
elseif ( $db_fzg_typ &0x40 )
{
$FZG="PKW";
}
$db_fzg_zeit=checktimeval ($row['fzg_zeit']);
$db_fzg_ziel=checkval ($row['fzg_ziel']);
$db_reg_time=checktimeval ($row['reg_time']);
$db_san_diag=checkval ($row['san_diag']);
$db_san_comm=checkval ($row['san_comm']);
$db_san_time=checktimeval ($row['san_time']);
// print values
?>
<tr>
<td width="70" valign="top" align="middle"><p id="sw10_s"><? echo $db_pat_nr; ?></td>
<td width="60" valign="top" align="middle"><p id="sw10_s"><? echo $db_reg_time; ?></td>
<td width="60" valign="top" align="middle"><p id="sw10_s"><? echo $db_san_time; ?></td>
<td width="200" valign="top" align="left" ><p id="sw10_s"><? echo $db_san_diag . "<br>" . $db_san_comm; ?></td>
<td width="150" valign="top" align="left" ><p id="sw10_s"><? echo $db_pat_nname . "<br>" . $db_pat_vname . "<br>". $db_pat_geb; ?></td>
<td width="150" valign="top" align="left" ><p id="sw10_s"><? echo $db_pat_ort . "<br>" . $db_pat_str; ?></td>
<td width="60" valign="top" align="middle"><p id="sw10_s"><? echo $FZG . "<br>" . $db_fzg_name; ?></td>
<td width="70" valign="top" align="middle"><p id="sw10_s"><? echo $db_fzg_zeit; ?></td>
<td width="130" valign="top" align="middle"><p id="sw10_s"><? echo $db_fzg_ziel . "<br>" . $RLS; ?></td>
</tr>
<tr>
<td colspan="9" height="1" width="950" style="background-color: #999999;"><img src="../_img/spacer.gif" height="1" width="950" border="0"></td>
</tr>
<?
}
?>
</table>
<p align="center" id="sw7_s"><? echo $FOOTNOTE; ?><BR>(c) 2005-2006 by Marcus Groh</p>
</center>
<?
include ('../_include/footer_2.php4');
?>