Codeigniter显示产品过期日期而不是库存

Question

我想展示的不是库存预警产品，而是有效期预警产品。

<?php

                foreach ($stock as $item) {
                    echo '<li class="list-group-item"><span class="badge badge-danger float-xs-right">' . +$item['qty'] . ' ' . $item['unit'] . '</span> <a href="' . base_url() . 'products/edit?id=' . $item['pid'] . '">' . $item['product_name'] . '  </a><small class="purple"> <i class="ft-map-pin"></i> ' . $item['title'] . '</small>
                            </li>';
                } ?>

和

    public function stock()
{
    $whr = '';
            if ($this->aauth->get_user()->loc) {
     $whr = ' AND (lmpos_warehouse.loc=' . $this->aauth->get_user()->loc . ')';
    } elseif (!BDATA) {
     $whr = ' AND (lmpos_warehouse.loc=0)';
    }

    $query = $this->db->query("SELECT lmpos_products.*,lmpos_warehouse.title FROM lmpos_products LEFT JOIN lmpos_warehouse ON lmpos_products.warehouse=lmpos_warehouse.id  WHERE (lmpos_products.qty<=lmpos_products.alert) $whr ORDER BY lmpos_products.product_name ASC LIMIT 10");
    return $query->result_array();
}

注意:在数据库的产品表中，每个产品都有一个过期日期

You can see the current result in this photo

Answer 1

例如，您有一个名为exp的过期日期数据库表列，只需将工卡代码从+$item['qty'] . ' ' . $item['unit']更改为date("F jS, Y", strtotime($item['exp'])：

    foreach ($stock as $item) {
        echo '<li class="list-group-item"><span class="badge badge-danger float-xs-right">' . date("F jS, Y", strtotime($item['exp']) . '</span> <a href="' . base_url() . 'products/edit?id=' . $item['pid'] . '">' . $item['product_name'] . '  </a><small class="purple"> <i class="ft-map-pin"></i> ' . $item['title'] . '</small>
                </li>';
    }

这将以人类可读的格式显示过期日期