<?php

/**
 * @author Bettina Schwarzer, Fritz-Haber-Institut
 * @copyright 01/2012
 * 
 * Bestaetigen Laser - INSERT/UPDATE-Daten
 */


            echo "<table>\n";
            echo "<tr><td>Laser-ID: </td><td>" . $la["lid"] . "</td></tr>\n";
            if ($la["lidref"])
            {
                $sql = "SELECT las_bez FROM Laser WHERE las_ID = " . $la["lidref"]; 
                if ($res = $dbc -> queryObjectArray($sql))
                    foreach ($res as $row)
                        echo "<tr><td>zu Laser: </td><td>". $la["lidref"]." - $row->las_bez</td></tr>\n";
            }
            echo "<tr><td>Laserbezeichnung: </td><td>" . $la['lbez'] . "</td></tr>\n";
            echo "<tr><td>Inventar-Nr.: </td><td>" . $la['invnr'] . "</td></tr>\n";
            echo "<tr><td>Laserwelle von - bis: </td><td>" . $la['wvon'] . " - " . $la['wbis'] . "</td></tr>\n";
            // Laserart
            $sql = "SELECT las_art_bez FROM Laser_Art WHERE las_art_ID = " . $la["lart"];
            if ($res = $dbc -> queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Laserart: </td><td>$row->las_art_bez</td></tr>\n";
            // Lasertyp
            $sql = "SELECT las_typ_bez FROM Laser_Typ WHERE las_typ_ID = " . $la["ltyp"];
            if ($res = $dbc -> queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Lasertyp: </td><td>$row->las_typ_bez</td></tr>\n";
            // Laserklasse
            $sql = "SELECT las_klasse_bez FROM Laser_Klasse WHERE las_klasse_ID = '" . $la["lkla"] ."'";
            if ($res = $dbc -> queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Laserklasse: </td><td>$row->las_klasse_bez</td></tr>\n";
            // Schutzstufe
            $sql = "SELECT schutzst_bez FROM Schutzstufe WHERE schutzst_ID = '" . $la["suid"] ."'";
            if ($res = $dbc -> queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Schutzstufe: </td><td>$row->schutzst_bez</td></tr>\n";
            $sql = "SELECT schutzst_bez FROM Schutzstufe WHERE schutzst_ID = '" . $la["suodid"] ."'";
            if ($res = $dbc -> queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Schutzstufe OD: </td><td>$row->schutzst_bez</td></tr>\n";
                
            $sql = "SELECT einheit_ID,einheit,einheit_beschr FROM Einheit WHERE laser>0 ORDER BY right(einheit,1),2";
                if ($ree = $dbc -> queryObjectArray($sql))
                    foreach ($ree as $row)
                    {
                        if ($row->einheit_ID == $la["eleist"]) $eleist = $row->einheit;
                        if ($row->einheit_ID == $la["eleistmax"]) $eleistmax = $row->einheit;
                        if ($row->einheit_ID == $la["eeng"]) $eeng = $row->einheit;
                        if ($row->einheit_ID == $la["eapt"]) $eapt = $row->einheit;
                        if ($row->einheit_ID == $la["efrq"]) $efrq = $row->einheit;
                        if ($row->einheit_ID == $la["eipb"]) $eipb = $row->einheit;
                    }
            if ($la["leist"])
                echo "<tr><td>Leistung: </td><td>".$la["leist"]." $eleist</td></tr>\n";
            if ($la["leistmax"])
                echo "<tr><td>max. Leistung: </td><td>".$la["leistmax"]." $eleistmax</td></tr>\n";
            if ($la["eng"])
                echo "<tr><td>Energie: </td><td>".$la["eng"]." $eeng</td></tr>\n";
            if ($la["apt"])
                echo "<tr><td>Apertur: </td><td>".$la["apt"]." $eapt</td></tr>\n";
            if ($la["frq"])
                echo "<tr><td>Frequenz: </td><td>".$la["frq"]." $efrq</td></tr>\n";
            if ($la["ipb"])
                echo "<tr><td>Impulsbreite: </td><td>".$la["ipb"]." $eipb</td></tr>\n";
            echo "<tr><td>in Betrieb: </td><td>"; echo ($la["akt"]) ? "ja" : "nein";  echo "</td></tr>\n";
            if ($la["hstid"])
            {
                $sql = "SELECT las_hersteller_bez FROM fhiiqm.Laser_Hersteller WHERE las_hersteller_ID = ".$la["hstid"];
                if ($res = $dbc->queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Hersteller: </td><td>$row->las_hersteller_bez</td></tr>\n";
            }
            if ($la["raum"])
            {
                $sql = "SELECT raum_nr, raum_name FROM fhiiqm.Raum WHERE raum_ID = " . $la['raum'];
                if ($res = $dbc->queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Standort: </td><td>Geb&auml;ude " . $la["geb"] .": $row->raum_nr, $row->raum_name</td></tr>\n";
            }
            if ($la["pid"])
            {
                $sql = "SELECT  CONCAT (nachname, ', ',vorname) AS ma FROM  fhiiqm.Mitarbeiter WHERE persknr = " . $la["pid"];
                if ($res = $dbc->queryObjectArray($sql))
                foreach ($res as $row)
                    echo "<tr><td>Verantwortlicher: </td><td>$row->ma</td></tr>\n";
            }
            if ($la["linfo"])
                echo "<tr><td>Laserinfo: </td><td>" . nl2br($la['linfo']) . "</td></tr>\n";
            //timestamp
            $sql = "SELECT timestamp FROM Laser WHERE las_ID = " . $la["lid"];
            if ($res = $dbc->queryObjectArray($sql))
            foreach ($res as $row)
            {
                $ts = new DateTime($row->timestamp);
                if ($ts && $ts>0)
                    echo "<tr><td>Letze Änderung: </td><td>" . $ts->format('d.m.Y H:i:s')."</td></tr>\n"; 
            }

            echo "</table>\n";
?>