|
|
 ID |
Product
|
Supplier
|
Category
|
QuantityPerUnit
|
UnitPrice
|
|
53
|
Perth Pasties
|
G'day, Mate
|
Meat/Poultry
|
48 pieces
|
32.80
|
UnitsInStock
|
UnitsOnOrder
|
ReorderLevel
|
Discontinued
|
Notes
|
OrderDate
|
|
0
|
0
|
0
|
1
|
|
|
|
Notes
This uses a template file called bottom.tpl to change the detail view to a two row table.
The template file looks like this:
<!-- BEGIN phpLens Detail outbot. Place in templates directory and set templateDetail property to file name. -->
<table width="100%" border="1" bgcolor="#CCCCFF">
<tr>
<td>
<div align="center"><b>{$PRODUCTID_T}</b></div>
</td>
<td>
<div align="center"><b>{$PRODUCTNAME_T}</b></div>
</td>
<td>
<div align="center"><b>{$SUPPLIERID_T}</b></div>
</td>
<td>
<div align="center"><b>{$CATEGORYID_T}</b></div>
</td>
<td>
<div align="center"><b>{$QUANTITYPERUNIT_T}</b></div>
</td>
<td>
<div align="center"><b>{$UNITPRICE_T}</b></div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">{$PRODUCTID}</div>
</td>
<td>
<div align="center">{$PRODUCTNAME}</div>
</td>
<td>
<div align="center">{$SUPPLIERID}</div>
</td>
<td>
<div align="center">{$CATEGORYID}</div>
</td>
<td>
<div align="center">{$QUANTITYPERUNIT}</div>
</td>
<td>
<div align="center">{$UNITPRICE}</div>
</td>
</tr>
<tr>
<td>
<div align="center"><b>{$UNITSINSTOCK_T}</b></div>
</td>
<td>
<div align="center"><b>{$UNITSONORDER_T}</b></div>
</td>
<td>
<div align="center"><b>{$REORDERLEVEL_T}</b></div>
</td>
<td>
<div align="center"><b>{$DISCONTINUED_T}</b></div>
</td>
<td>
<div align="center"><b>{$NOTES_T}</b></div>
</td>
<td>
<div align="center"><b>{$ORDERDATE_T}</b></div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">{$UNITSINSTOCK}</div>
</td>
<td>
<div align="center">{$UNITSONORDER}</div>
</td>
<td>
<div align="center">{$REORDERLEVEL}</div>
</td>
<td>
<div align="center">{$DISCONTINUED}</div>
</td>
<td>
<div align="center">{$NOTES}</div>
</td>
<td>
<div align="center">{$ORDERDATE}</div>
</td>
</tr>
</table>
<!-- END phpLens Detail outbot -->