<thead>
<?php
echo create_table_header($result);
?>
</thead>
<tbody>
<?php
echo create_table_body($result, "payments.php");
?>
</tbody>
</table>
<?php
$query = "SELECT * FROM TransactionItems WHERE TrxID=" . intval($_GET['id']);
$result = mysql_query($query) or die($query . "<br />" . mysql_error());
?>
<h2>Transaction Items</h2>
<table>
<thead>
<?php
echo create_table_header($result);
?>
</thead>
<tbody>
<?php
echo create_table_body($result, "trxitem.php");
?>
</tbody>
</table>
<?php
}
echo footer();
*
* This file is to help people explore PO's.
*
* Created by Rodolphe Courtier
*/
require_once 'config.php';
$query_extra = "";
if (isset($_GET['id'])) {
$query_extra = "WHERE ID=" . $_GET['id'];
}
$query = "SELECT * FROM PurchaseOrderItems " . $query_extra . " ORDER BY ID DESC LIMIT 100";
$result = mysql_query($query) or die($query . "<br />" . mysql_error());
?>
<?php
echo head("Purchase Order Items", basename(__FILE__));
?>
<table>
<thead>
<?php
echo create_table_header($result);
?>
</thead>
<tbody>
<?php
echo create_table_body($result, basename(__FILE__));
?>
</tbody>
</table>
<?php
echo footer();
<?php
echo create_table_header($result);
?>
</thead>
<tbody>
<?php
echo create_table_body($result, basename(__FILE__));
?>
</tbody>
</table>
<?php
if (isset($_GET['id'])) {
$query = "SELECT * FROM PurchaseOrderReceiptItems WHERE ReceiptID=" . $_GET['id'];
$result = mysql_query($query) or die($query . "<br />" . mysql_error());
?>
<h2>Purchase Order Receipt Items</h2>
<table>
<thead>
<?php
echo create_table_header($result);
?>
</thead>
<tbody>
<?php
echo create_table_body($result, "poreceiptitem.php");
?>
</tbody>
</table>
<?php
}
echo footer();
