Mercurial Mercurial > IQM / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fhiiqm/report/gefahr_ap_report.php
changeset 34 fc60ef80a7ad
parent 29 72f79dab938e
equal deleted inserted replaced
33:f1a8785434e4 34:fc60ef80a7ad 
     7  * Arbeitsicherheit
 
     7  * Arbeitsicherheit
 
     8  */
 
     8  */
 
     9 
     9 
    10     error_reporting(E_ALL ^ E_NOTICE);
 
    10     error_reporting(E_ALL ^ E_NOTICE);
 
    11     
    11     
    12     session_start();
 
    12     if (!isset($_GET['s']) || $_GET['s'] != 2 )
 
    13     if (! isset($_SESSION["userid"]))
 
    13     {
 
    14     { 
    14         session_start();
 
    15         include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");	
    15         if (! isset($_SESSION["userid"]))
 
    16         login($_SERVER["PHP_SELF"]);
 
    16         { 
    17         exit;
 
    17             include_once ($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/func_lib.inc.php");	
    18     }
 
    18             login($_SERVER["PHP_SELF"]);
 
    19     
    19             exit;
 
    20     if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("asr",$_SESSION["recht"]) && !in_array("ase",$_SESSION["recht"])))
 
    20         }
 
    21     {
 
    21         
    22         header("Location: start.php");
 
    22         if (is_null($_SESSION["recht"]) || (!is_null($_SESSION["recht"]) && !in_array("asr",$_SESSION["recht"]) && !in_array("ase",$_SESSION["recht"])))
 
    23         exit;
 
    23         {
 
       
    24             header("Location: start.php");
 
       
    25             exit;
 
       
    26         }    
    24     }    
    27     }    
    25 
    28 
    26 ?>
 
    29 ?>
 
    27 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
    30 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
    28 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 
    31 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 
    36 
    39 
    37 <body>
 
    40 <body>
 
    38 
    41 
    39 <?php    
    42 <?php    
    40     echo "&nbsp;";  
    43     echo "&nbsp;";  
    41     echo "<div class=\"float-br smaller\" valign='top'>";
 
    44     if (!isset($_GET['s']) || $_GET['s'] != 2 )
 
    42     echo "&nbsp;&nbsp;&nbsp;user: " . $_SESSION["userid"];
 
    45     {
 
    43     echo "&nbsp;&nbsp;&nbsp;<a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
 
    46         echo "<div class=\"float-br smaller\" valign='top'>";
 
       
    47         echo "&nbsp;&nbsp;&nbsp;user: " . $_SESSION["userid"];
 
       
    48         echo "&nbsp;&nbsp;&nbsp;<a class='sc' href='/fhiiqm/logout.php' title='Session beenden'>logout</a></div>\n";
 
       
    49     }
 
    44     echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/role.png\" border=\"0\" alt=\"Raum-Gefahr\" title=\"Raum-Gefahr\"/></div>\n";
 
    50     echo "<div class=\"float-r\"><img src=\"/fhiiqm/img/role.png\" border=\"0\" alt=\"Raum-Gefahr\" title=\"Raum-Gefahr\"/></div>\n";
 
    45     
    51     
    46     $rag    = $_POST["rag"];    // Parameter aus Form
 
    52     $rag    = $_POST["rag"];    // Parameter aus Form
 
    47     $search = $_POST["search"];
 
    53     $search = $_POST["search"];
 
    48     if (!$search) $search =  $_GET["s"];
 
    54     if (!$search) $search =  $_GET["s"];
 
    75     $_GET["s2"] = $rag["sort2"];
 
    81     $_GET["s2"] = $rag["sort2"];
 
    76     $_GET["s3"] = $rag["sort3"];
 
    82     $_GET["s3"] = $rag["sort3"];
 
    77     $_GET["s4"] = $rag["sort4"];
 
    83     $_GET["s4"] = $rag["sort4"];
 
    78     $_GET["z"]  = $zeil;
 
    84     $_GET["z"]  = $zeil;
 
    79    
    85    
    80     if ($search)
 
    86     if ($search && $_GET['s'] != 2)
 
    81     {    
    87     {    
    82         echo "<span class='sc'>";
 
    88         echo "<span class='sc'>";
 
    83         echo "<br />&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>&laquo; zur Berichts&uuml;bersicht</a>";
 
    89         echo "<br />&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>&laquo; zur Berichts&uuml;bersicht</a>";
 
    84         echo "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;<a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Raum-Typ\" class=\"sc\">neuer Arbeitsplatz-Gef&auml;hrdungen Bericht</a>\n";    
    90         echo "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;<a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Raum-Typ\" class=\"sc\">neuer Arbeitsplatz-Gef&auml;hrdungen Bericht</a>\n";    
    85         echo "</span>";
 
    91         echo "</span>";
 
   228             }   
   234             }   
   229             echo "</table>\n";
 
   235             echo "</table>\n";
 
   230             echo "</div>\n";
 
   236             echo "</div>\n";
 
   231 
   237 
   232             echo "<br />&nbsp;&nbsp;&nbsp;";
 
   238             echo "<br />&nbsp;&nbsp;&nbsp;";
 
   233             // Parameter aus $_GET fuer weitere Seiten
 
   239             if ($search != 2) // Aufruf aus fhiiqm
 
   234             $_GET["s"] = 1; // bewirkt weitere Suche
 
   240             {    
   235             foreach ($_GET as $key=>$val)
 
   241                 // Parameter aus $_GET fuer weitere Seiten
 
       
   242                 $_GET["s"] = 1; // bewirkt weitere Suche
 
       
   243                 foreach ($_GET as $key=>$val)
 
       
   244                 {
 
       
   245                     if ($key != "st") $liste .= "&" . $key ."=".$val;
 
       
   246                 }    
       
   247                 // Links auf andere Seiten generieren
 
       
   248                 liste_links($start,$zeil,$ianz,$liste);
 
       
   249             }
 
       
   250 
       
   251             if ($search != 2)
 
   236             {
 
   252             {
 
   237                 if ($key != "st") $liste .= "&" . $key ."=".$val;
 
   253                 echo "<p style=\"page-break-before:always\"></p>";
 
   238             }    
   254                 
   239             // Links auf andere Seiten generieren
 
   255                 echo "<div align='center'>\n";
 
   240             liste_links($start,$zeil,$ianz,$liste);
 
   256                 $sql = "SELECT DISTINCT a.gefahr_ID, gefahr_bez, asm_bez, asm_bem, gf_asm_nr 
   241 
   257                         FROM Raum r LEFT OUTER JOIN Raum_Typ rt ON r.raumtyp_ID = rt.raumtyp_ID
 
   242             echo "<p style=\"page-break-before:always\"></p>";
 
   258                             LEFT OUTER JOIN Raum_Arbplatz_Typ ra ON ra.raum_ID = r.raum_ID
 
   243             
   259                             LEFT OUTER JOIN Arbplatz_Typ at ON ra.arbplatz_typ = at.arbplatz_typ
 
   244             echo "<div align='center'>\n";
 
   260                             LEFT OUTER JOIN Gefahr_Arbplatz a ON a.arbplatz_typ = at.arbplatz_typ
 
   245             $sql = "SELECT DISTINCT a.gefahr_ID, gefahr_bez, asm_bez, asm_bem, gf_asm_nr 
   261                             LEFT OUTER JOIN Gefahr g ON a.gefahr_ID = g.gefahr_ID
 
   246                     FROM Raum r LEFT OUTER JOIN Raum_Typ rt ON r.raumtyp_ID = rt.raumtyp_ID
 
   262                             LEFT OUTER JOIN AS_Massnahme m ON a.gefahr_ID = m.gefahr_ID ";
 
   247                         LEFT OUTER JOIN Raum_Arbplatz_Typ ra ON ra.raum_ID = r.raum_ID
 
   263                 if ($where)
 
   248                         LEFT OUTER JOIN Arbplatz_Typ at ON ra.arbplatz_typ = at.arbplatz_typ
 
   264                     $sql .= $where . " AND NOT (a.Gefahr_ID IS NULL)";
 
   249                         LEFT OUTER JOIN Gefahr_Arbplatz a ON a.arbplatz_typ = at.arbplatz_typ
 
   265                 else
 
   250                         LEFT OUTER JOIN Gefahr g ON a.gefahr_ID = g.gefahr_ID
 
   266                     $sql .= " WHERE NOT (a.Gefahr_ID IS NULL)";
 
   251                         LEFT OUTER JOIN AS_Massnahme m ON a.gefahr_ID = m.gefahr_ID ";
 
   267                 $sql .= " ORDER BY gefahr_ID,asm_bez";
 
   252             if ($where)
 
   268                 $resm = $dbc -> queryObjectArray($sql);
 
   253                 $sql .= $where . " AND NOT (a.Gefahr_ID IS NULL)";
 
   269                 
   254             else
 
   270                 if ($resm)
 
   255                 $sql .= " WHERE NOT (a.Gefahr_ID IS NULL)";
 
   271                 {
 
   256             $sql .= " ORDER BY gefahr_ID,asm_bez";
 
   272             		$bg1 = "#F8F8F8";
 
   257             $resm = $dbc -> queryObjectArray($sql);
 
   273             		$bg2 = "#DEDFE1";
 
   258             
   274             		$bg = "#FFFFFF";
 
   259             if ($resm)
 
   275                     echo "<table width='80%' border='1' cellspacing='0' cellpadding='2'>\n";
 
   260             {
 
   276                     // Listenkopf
 
   261         		$bg1 = "#F8F8F8";
 
   277                     echo "<tr bgcolor='#68ACBF'>";
 
   262         		$bg2 = "#DEDFE1";
 
   278                     echo "<th>Gef&auml;hrdung</th>";
 
   263         		$bg = "#FFFFFF";
 
   279                     echo "<th>Ma&szlig;nahme-Bez.</th>";
 
   264                 echo "<table width='80%' border='1' cellspacing='0' cellpadding='2'>\n";
 
   280                     echo "<th width='40%'>Ma&szlig;nahme</th>";
 
   265                 // Listenkopf
 
   281                     echo "</tr>";
 
   266                 echo "<tr bgcolor='#68ACBF'>";
 
   282         
   267                 echo "<th>Gef&auml;hrdung</th>";
 
   283                     foreach ($resm as $row)
 
   268                 echo "<th>Ma&szlig;nahme-Bez.</th>";
 
   284                     {
 
   269                 echo "<th width='40%'>Ma&szlig;nahme</th>";
 
   285             			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
 
   270                 echo "</tr>";
 
   286                         echo "<tr bgcolor='" . $bg . "'>"; 
   271     
   287                         echo "<td>$row->gefahr_ID - $row->gefahr_bez</td>";
 
   272                 foreach ($resm as $row)
 
   288                         echo "<td>$row->asm_bez</td>";
 
   273                 {
 
   289                         echo "<td width='50%'>".nl2br($row->asm_bem)."</td></tr>\n";
 
   274         			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
 
   290                     }
 
   275                     echo "<tr bgcolor='" . $bg . "'>"; 
   291                     echo "</table>\n";
 
   276                     echo "<td>$row->gefahr_ID - $row->gefahr_bez</td>";
 
   292                 }            
   277                     echo "<td>$row->asm_bez</td>";
 
   293             }
 
   278                     echo "<td width='50%'>".nl2br($row->asm_bem)."</td></tr>\n";
 
       
   279                 }
 
       
   280                 echo "</table>\n";
 
       
   281             }            
       
   282 
   294 
   283             echo "<p></p><table width=80%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
 
   295             echo "<p></p><table width=80%><tr><td class='right'><a href=\"javascript:window.print()\" class='sc'>
 
   284                 <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
 
   296                 <img src=\"/fhiiqm/img/printer.png\" alt=\"Bericht drucken\" border=\"0\" align=\"right\" title=\"Bericht drucken\"></a></td></tr></table>";
 
   285             echo "</div>\n";
 
   297             echo "</div>\n";
 
   286             
   298             
   288         else
 
   300         else
 
   289         {
 
   301         {
 
   290             echo "<p class='red'>&nbsp;&nbsp;&nbsp;Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
 
   302             echo "<p class='red'>&nbsp;&nbsp;&nbsp;Leider gibt es kein Ergebnis für die von Ihnen gewählten Kriterien!</p>";
 
   291             echo "</div>\n";
 
   303             echo "</div>\n";
 
   292         }
 
   304         }
 
   293         echo "<span class='sc'>";
 
   305         if ($search != 2)
 
   294         echo "<br /><br />&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>&laquo; zur Berichts&uuml;bersicht</a>";
 
   306         {    
   295         echo "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;<a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Raum-Typ\" class=\"sc\">neuer Arbeitsplatz-Gef&auml;hrdungen Bericht</a>\n";    
   307             echo "<span class='sc'>";
 
   296         echo "</span>";
 
   308             echo "<br /><br />&nbsp;&nbsp;&nbsp;<a href=\"/fhiiqm/as_report.php\" target=\"_self\" title=\"Berichte\" class='sc'>&laquo; zur Berichts&uuml;bersicht</a>";
 
       
   309             echo "&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;<a href=\"" . $_SERVER["PHP_SELF"] . "\" target=\"_self\" title=\"Raum-Typ\" class=\"sc\">neuer Arbeitsplatz-Gef&auml;hrdungen Bericht</a>\n";    
       
   310             echo "</span>";
 
       
   311         }
 
       
   312         else
 
       
   313             echo "<a href='javascript:history.back();' onMouseOver=\"{window.status='Zur&uuml;ck'; return true;}\">&nbsp;&nbsp;&nbsp;&laquo; Zur&uuml;ck</a>";
 
   297     }
 
   314     }
 
   298 
   315 
   299 ?>
 
   316 ?>
 
   300 
   317 
   301 </body>
 
   318 </body>
IQM