43 lines
1.3 KiB
PHP
Executable File
43 lines
1.3 KiB
PHP
Executable File
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');?>
|
|
<table class="table" width="1500" border="1">
|
|
<thead>
|
|
<tr>
|
|
<th colspan="10" align="center"><h3>库存预警商品</h3></th>
|
|
</tr>
|
|
|
|
<tr>
|
|
<th width="80" >商品编号</th>
|
|
<th width="100" >商品名称</th>
|
|
<th width="80" >商品类别</th>
|
|
<th width="80" >规格型号</th>
|
|
<th width="80" >单位</th>
|
|
<th width="80" >仓库</th>
|
|
<th width="80" >最低库存</th>
|
|
<th width="80" >最高库存</th>
|
|
<th width="80" >结存数量</th>
|
|
<th width="80" >超限数量</th>
|
|
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$i = 1;
|
|
foreach($list as $arr=>$row) {
|
|
?>
|
|
<tr target="id">
|
|
<td ><?php echo $row['invNumber']?></td>
|
|
<td ><?php echo $row['invName']?></td>
|
|
<td ><?php echo $row['categoryName']?></td>
|
|
<td ><?php echo $row['invSpec']?></td>
|
|
<td ><?php echo $row['unitName']?></td>
|
|
<td ><?php echo $row['locationName']?></td>
|
|
<td ><?php echo $row['lowQty']?></td>
|
|
<td ><?php echo $row['highQty']?></td>
|
|
<td ><?php echo $row['qty']?></td>
|
|
<td ><?php echo $row['qty1'] > 0 ? $row['qty1'] : $row['qty2']; ?></td>
|
|
</tr>
|
|
<?php $i++;}?>
|
|
|
|
</tbody>
|
|
</table>
|