110 lines
2.8 KiB
PHP
110 lines
2.8 KiB
PHP
|
<?php // php pages made with phpMyBuilder <http://kyber.dk/phpMyBuilder> ?>
|
||
|
|
<?php
|
||
|
|
// (C) Copyright 2001
|
||
|
|
// Murray Jensen <Murray.Jensen@csiro.au>
|
||
|
|
// CSIRO Manufacturing Science and Technology, Preston Lab
|
||
|
|
|
||
|
|
// list page (hymod_bddb / boards)
|
||
|
|
|
||
|
|
require("defs.php");
|
||
|
|
|
||
|
|
pg_head("$bddb_label - Browse Board Log");
|
||
|
|
|
||
|
|
$serno=intval($serno);
|
||
|
|
if ($serno == 0)
|
||
|
|
die("serial number not specified or invalid!");
|
||
|
|
|
||
|
|
function print_cell($str) {
|
||
|
|
if ($str == '')
|
||
|
|
$str = ' ';
|
||
|
|
echo "\t<td>$str</td>\n";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<table align=center border=1 cellpadding=10>
|
||
|
|
<tr>
|
||
|
|
<th>serno / edit</th>
|
||
|
|
<th>ethaddr</th>
|
||
|
|
<th>date</th>
|
||
|
|
<th>batch</th>
|
||
|
|
<th>type</th>
|
||
|
|
<th>rev</th>
|
||
|
|
<th>location</th>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
$r=mysql_query("select * from boards where serno=$serno");
|
||
|
|
|
||
|
|
while($row=mysql_fetch_array($r)){
|
||
|
|
foreach ($columns as $key) {
|
||
|
|
if (!key_in_array($key, $row))
|
||
|
|
$row[$key] = '';
|
||
|
|
}
|
||
|
|
|
||
|
|
echo "<tr>\n";
|
||
|
|
print_cell("<a href=\"edit.php?serno=$row[serno]\">$row[serno]</a>");
|
||
|
|
print_cell($row['ethaddr']);
|
||
|
|
print_cell($row['date']);
|
||
|
|
print_cell($row['batch']);
|
||
|
|
print_cell($row['type']);
|
||
|
|
print_cell($row['rev']);
|
||
|
|
print_cell($row['location']);
|
||
|
|
echo "</tr>\n";
|
||
|
|
}
|
||
|
|
|
||
|
|
mysql_free_result($r);
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
<hr></hr>
|
||
|
|
<p></p>
|
||
|
|
<?php
|
||
|
|
$limit=abs(isset($_REQUEST['limit'])?$_REQUEST['limit']:20);
|
||
|
|
$offset=abs(isset($_REQUEST['offset'])?$_REQUEST['offset']:0);
|
||
|
|
$lr=mysql_query("select count(*) as n from log where serno=$serno");
|
||
|
|
$lrow=mysql_fetch_array($lr);
|
||
|
|
if($lrow['n']>$limit){
|
||
|
|
$preoffset=max(0,$offset-$limit);
|
||
|
|
$postoffset=$offset+$limit;
|
||
|
|
echo "<table width=\"100%\">\n<tr align=center>\n";
|
||
|
|
printf("<td><%sa href=\"%s?submit=Log&serno=$serno&offset=%d\"><img border=0 alt=\"<\" src=\"/icons/left.gif\"></a></td>\n", $offset>0?"":"no", $PHP_SELF, $preoffset);
|
||
|
|
printf("<td><%sa href=\"%s?submit=Log&serno=$serno&offset=%d\"><img border=0 alt=\">\" src=\"/icons/right.gif\"></a></td>\n", $postoffset<$lrow['n']?"":"no", $PHP_SELF, $postoffset);
|
||
|
|
echo "</tr>\n</table>\n";
|
||
|
|
}
|
||
|
|
mysql_free_result($lr);
|
||
|
|
?>
|
||
|
|
<table width="100%" border=1 cellpadding=10>
|
||
|
|
<tr valign=top>
|
||
|
|
<th>logno / edit</th>
|
||
|
|
<th>date</th>
|
||
|
|
<th>who</th>
|
||
|
|
<th width="70%">details</th>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
$r=mysql_query("select * from log where serno=$serno order by logno limit $offset,$limit");
|
||
|
|
|
||
|
|
while($row=mysql_fetch_array($r)){
|
||
|
|
echo "<tr>\n";
|
||
|
|
print_cell("<a href=\"edlog.php?serno=$row[serno]&logno=$row[logno]\">$row[logno]</a>");
|
||
|
|
print_cell($row['date']);
|
||
|
|
print_cell($row['who']);
|
||
|
|
print_cell("<pre>" . urldecode($row['details']) . "</pre>");
|
||
|
|
echo "</tr>\n";
|
||
|
|
}
|
||
|
|
|
||
|
|
mysql_free_result($r);
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
<hr></hr>
|
||
|
|
<p></p>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<td align=center>
|
||
|
|
<a href="newlog.php?serno=<?php echo "$serno"; ?>">Add to Log</a>
|
||
|
|
</td>
|
||
|
|
<td align=center>
|
||
|
|
<a href="index.php">Back to Start</a>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
<?php
|
||
|
|
pg_foot();
|
||
|
|
?>
|