<html>
<header>
<title>PRA verwalten</title>
<style type="text/css">
#table_m {border:solid 1px #000000; border-collapse:collapse; font-family:Arial; font-size:11;}
#table_o {border:solid 0px #000000; border-collapse:collapse; font-family:Arial; font-size:11;}
#th { border:1px solid black; }
#td { border:1px solid black;}
input {font-size:9;}
#input_s {width=12; align:center; border-width:0px;}
</style>
<script type="text/javascript">
function edit_window(pra)
{
fenster = window.open('pra_edit.php?pra='+pra, 'Fenster', 'width=400, height=330, scrollbars=no, top=300, left=400');
fenster.focus();
}
function open_window_newpra()
{
fenster = window.open('pra_new.php', 'Fenster', 'width=400, height=430, scrollbars=no, top=300, left=400');
fenster.document.bgColor = "Gainsboro";
fenster.focus();
}
function report_open(pra)
{
URL='rep_interim_report.php?pra='+pra;
window.location=URL;
}
</script>
</header>
<body>
<?php
$nr = $_GET[user];
// MYSQL-Connect
$mysql_user = "xxxx";
$mysql_pwd = "xxxx";
$mysql_host = "xxxx";
$mysql = mysql_connect($mysql_host, $mysql_user, $mysql_pwd);
mysql_select_db('prod');
if (isset($_GET[close]))
{
foreach ($close as $key => $val)
{
$data_pra = substr($key,0,strpos($key,'-'));
$data_status = substr($key,strpos($key,'-')+1,1);
}
if ($data_status == 0)
mysql_query("UPDATE pra SET status = '1' WHERE pra = '$data_pra'");
else
mysql_query("UPDATE pra SET status = '0', cdate = '".date('Y-m-d')."' WHERE pra = '$data_pra'");
$url = $_SERVER['REQUEST_URI'];
if(preg_match("/Abschliessen/",$url))
{
echo "<script type='text/javascript'>";
echo "URL='rep_pra_close.php?pra=".$data_pra."';";
echo "window.location=URL;";
echo "</script>";
}
}
// Tabellentitel
echo "<form>";
echo "<table id=table_m align=center>";
echo "<colgroup>";
echo "<col width=70>"; // Prozess_nr
echo "<col width=120>"; // Mat_nr
echo "<col width=300>"; // Mat_bezeichnung
echo "<col width=150>"; // Mat_info
echo "<col width=50>"; // Fert.-St.
echo "<col width=125>"; // Edit
echo "</colgroup>";
echo "<tr>";
echo "<th id=th><a href=pra.php".$link."&order=pra>Prozess-Nr.</a></th>";
echo "<th id=th><a href=pra.php".$link."&order=mat_nr>Mat.-Nr.</a></th>";
echo "<th id=th><a href=pra.php".$link."&order=mat_bez>Material-Bezeichnung</a></th>";
echo "<th id=th><a href=pra.php".$link."&order=mat_info>Mat.-Info.</a></th>";
echo "<th id=th><a href=pra.php".$link."&order=vs>Fert.-St.</a></th><th id=th>Edit</th>";
echo "</tr>";
// Tabelleninhalt
$stat = "SELECT pra, mat_nr, mat_info, status, mat_bez, vs FROM pra";
$found = mysql_query($stat);
while ($data = mysql_fetch_row($found))
{
if ($data[3] == 0)
{
$color = "Red";
$disable = "disabled=disabled";
}
else
{
$color = "";
$disable = "";
}
$status = $data[0]."-".$data[3];
// Materialbezeichnung wrappen
$wrap_text = wordwrap($data[4], 40, "\n", true);
echo "<tr><td id=td><font color=".$color.">$data[0]</font>";
echo "<img src='info.png' width='14' height='14' onclick=report_open('$data[0]')>";
echo "</td><td id=td><font color=".$color.">$data[1]</font></td><td id=td><font color=".$color.">$wrap_text</font></td><td id=td><font color=".$color.">$data[2]</font></td><td id=td><font color=".$color.">$data[5]</font></td><td>";
echo "<input type=button name=edit value=Edit onclick=edit_window('$data[0]') ".$disable.">";
if ($data[3] == 1)
{
echo "<input type=submit name=close[$status] value=Abschliessen>";
}
else
{
echo "<input type=submit name=close[$status] value='Neu eröffnen'>";
}
echo "</td></tr>";
}
echo "</table>";
echo "</form>";
?>
</body>
</html>
